SAP Table MSQJOBSTEP
MS SQL server jobsteps ( as from msdb..sysjobsteps)
MSQJOBSTEP (MS SQL server jobsteps ( as from msdb..sysjobsteps)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MSQJOBSTEP to other SAP tables.
MSQJOBSTEP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| JOBID | MS SQL Server job ID | MSQJOBID | RAW | 16 | 0 | |||
| STEPID | MS SQL Server - the ID of the step in the job | MSQJBSTPID | INT4 | 10 | 0 | |||
| STEPNAME | MS SQL server - the name of the step | MSQJBSTPNA | CHAR | 100 | 0 | |||
| SUBSYSTEM | MS SQL server - Name of the subsystem used for job execution | MSQSUBSYS | CHAR | 60 | 0 | |||
| JOBCOMMAND | MS SQL server - command executed by the subsytem | MSQJOBCMD | CHAR | 520 | 0 | |||
| SUCCESSCDE | MS SQL server - success code returned by cmdexe subsystem | MSQSUCCCDE | INT4 | 10 | 0 | |||
| SUCCESSACT | MS SQL server - action to be performed after job success | MSQSUCCACT | INT2 | 5 | 0 | |||
| SUCCESSSTP | MS SQL Server - next step ID in job after job step success | MSQSUCSTID | INT4 | 10 | 0 | |||
| FAILACT | MSSQL Server - action to be performed after job step failure | MSQFAIACT | INT2 | 5 | 0 | |||
| FAILSTP | MS SQL server - next step after the failure of job step | MSQFAISTID | INT4 | 10 | 0 | |||
| DBASENAME | MS SQL server - name of the database in which job is exec. | MSQJBDNAME | CHAR | 64 | 0 | |||
| DBASEUNAME | MS SQL server - name of db user executing the step | MSQJBUNAME | CHAR | 64 | 0 | |||
| RETRY | MS SQL server - retry attempts for the job or step | MSQRETATTE | INT4 | 10 | 0 | |||
| RETRYINT | MS SQL server - wait interval between retry attempts | MSQRETINTE | INT4 | 10 | 0 | |||
| OUTPUTFILE | MS SQL server - the name of the job step's output file | MSQJBOUTFL | CHAR | 255 | 0 | |||
| LSTRUNSTA | MS SQL server - status of the previous exec. job step. | MSQLSTRUST | INT4 | 10 | 0 | |||
| LSTRUNDU | MS SQL server - time taken for the previous exec of the job | MSQLSTRUDU | INT4 | 10 | 0 | |||
| LSTRUNRET | MS SQL server - retry attempts of the last exec. of the job | MSQLSTRURE | INT4 | 10 | 0 | |||
| LSTRUNDT | MS SQL server - date of the job step's prev execution | MSQLSTRUDT | INT4 | 10 | 0 | |||
| LSTRUNTI | MS SQL server - time of the job step's previous execution | MSQLSTRUTI | INT4 | 10 | 0 | |||
