SAP MSQJOBSTEP table - MS SQL server jobsteps ( as from msdb..sysjobsteps) details in SAP

SAP MSQJOBSTEP table summary

Object Name: MSQJOBSTEP
Dictionary Type: Structure
Description: MS SQL server jobsteps ( as from msdb..sysjobsteps)

Field list for MSQJOBSTEP table on an S/4 SAP system

Details

MSQJOBSTEP-JOBID table field - MS SQL Server job ID ▼

Description: MS SQL Server job ID
Field Name: JOBID
Data Element: MSQJOBID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: MSQHEX16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field JOBID

MSQJOBSTEP-STEPID table field - MS SQL Server - the ID of the step in the job ▼

Description: MS SQL Server - the ID of the step in the job
Field Name: STEPID
Data Element: MSQJBSTPID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STEPID

MSQJOBSTEP-STEPNAME table field - MS SQL server - the name of the step ▼

Description: MS SQL server - the name of the step
Field Name: STEPNAME
Data Element: MSQJBSTPNA
Data Type: CHAR
length (Dec): 100(0)
Check table:
Conversion Routine:
Domain Name: CHAR100
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STEPNAME

MSQJOBSTEP-SUBSYSTEM table field - MS SQL server - Name of the subsystem used for job execution ▼

Description: MS SQL server - Name of the subsystem used for job execution
Field Name: SUBSYSTEM
Data Element: MSQSUBSYS
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: CHAR60
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SUBSYSTEM

MSQJOBSTEP-JOBCOMMAND table field - MS SQL server - command executed by the subsytem ▼

Description: MS SQL server - command executed by the subsytem
Field Name: JOBCOMMAND
Data Element: MSQJOBCMD
Data Type: CHAR
length (Dec): 520(0)
Check table:
Conversion Routine:
Domain Name: CHAR520
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field JOBCOMMAND

MSQJOBSTEP-SUCCESSCDE table field - MS SQL server - success code returned by cmdexe subsystem ▼

Description: MS SQL server - success code returned by cmdexe subsystem
Field Name: SUCCESSCDE
Data Element: MSQSUCCCDE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SUCCESSCDE

MSQJOBSTEP-SUCCESSACT table field - MS SQL server - action to be performed after job success ▼

Description: MS SQL server - action to be performed after job success
Field Name: SUCCESSACT
Data Element: MSQSUCCACT
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SUCCESSACT

MSQJOBSTEP-SUCCESSSTP table field - MS SQL Server - next step ID in job after job step success ▼

Description: MS SQL Server - next step ID in job after job step success
Field Name: SUCCESSSTP
Data Element: MSQSUCSTID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SUCCESSSTP

MSQJOBSTEP-FAILACT table field - MSSQL Server - action to be performed after job step failure ▼

Description: MSSQL Server - action to be performed after job step failure
Field Name: FAILACT
Data Element: MSQFAIACT
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAILACT

MSQJOBSTEP-FAILSTP table field - MS SQL server - next step after the failure of job step ▼

Description: MS SQL server - next step after the failure of job step
Field Name: FAILSTP
Data Element: MSQFAISTID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FAILSTP

MSQJOBSTEP-DBASENAME table field - MS SQL server - name of the database in which job is exec. ▼

Description: MS SQL server - name of the database in which job is exec.
Field Name: DBASENAME
Data Element: MSQJBDNAME
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: CHAR64
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBASENAME

MSQJOBSTEP-DBASEUNAME table field - MS SQL server - name of db user executing the step ▼

Description: MS SQL server - name of db user executing the step
Field Name: DBASEUNAME
Data Element: MSQJBUNAME
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: CHAR64
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBASEUNAME

MSQJOBSTEP-RETRY table field - MS SQL server - retry attempts for the job or step ▼

Description: MS SQL server - retry attempts for the job or step
Field Name: RETRY
Data Element: MSQRETATTE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RETRY

MSQJOBSTEP-RETRYINT table field - MS SQL server - wait interval between retry attempts ▼

Description: MS SQL server - wait interval between retry attempts
Field Name: RETRYINT
Data Element: MSQRETINTE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RETRYINT

MSQJOBSTEP-OUTPUTFILE table field - MS SQL server - the name of the job step's output file ▼

Description: MS SQL server - the name of the job step's output file
Field Name: OUTPUTFILE
Data Element: MSQJBOUTFL
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: CHAR255
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OUTPUTFILE

MSQJOBSTEP-LSTRUNSTA table field - MS SQL server - status of the previous exec. job step. ▼

Description: MS SQL server - status of the previous exec. job step.
Field Name: LSTRUNSTA
Data Element: MSQLSTRUST
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LSTRUNSTA

MSQJOBSTEP-LSTRUNDU table field - MS SQL server - time taken for the previous exec of the job ▼

Description: MS SQL server - time taken for the previous exec of the job
Field Name: LSTRUNDU
Data Element: MSQLSTRUDU
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LSTRUNDU

MSQJOBSTEP-LSTRUNRET table field - MS SQL server - retry attempts of the last exec. of the job ▼

Description: MS SQL server - retry attempts of the last exec. of the job
Field Name: LSTRUNRET
Data Element: MSQLSTRURE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LSTRUNRET

MSQJOBSTEP-LSTRUNDT table field - MS SQL server - date of the job step's prev execution ▼

Description: MS SQL server - date of the job step's prev execution
Field Name: LSTRUNDT
Data Element: MSQLSTRUDT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LSTRUNDT

MSQJOBSTEP-LSTRUNTI table field - MS SQL server - time of the job step's previous execution ▼

Description: MS SQL server - time of the job step's previous execution
Field Name: LSTRUNTI
Data Element: MSQLSTRUTI
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LSTRUNTI

View list of all SAP tables(S4H/ECC)

Select data from SAP table