Data Element list used by SAP ABAP Table MSQJOBSTEP (MS SQL server jobsteps ( as from msdb..sysjobsteps))
SAP ABAP Table
MSQJOBSTEP (MS SQL server jobsteps ( as from msdb..sysjobsteps)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | MSQFAIACT | MSSQL Server - action to be performed after job step failure | ||
| 2 | MSQFAISTID | MS SQL server - next step after the failure of job step | ||
| 3 | MSQJBDNAME | MS SQL server - name of the database in which job is exec. | ||
| 4 | MSQJBOUTFL | MS SQL server - the name of the job step's output file | ||
| 5 | MSQJBSTPID | MS SQL Server - the ID of the step in the job | ||
| 6 | MSQJBSTPNA | MS SQL server - the name of the step | ||
| 7 | MSQJBUNAME | MS SQL server - name of db user executing the step | ||
| 8 | MSQJOBCMD | MS SQL server - command executed by the subsytem | ||
| 9 | MSQJOBID | MS SQL Server job ID | ||
| 10 | MSQLSTRUDT | MS SQL server - date of the job step's prev execution | ||
| 11 | MSQLSTRUDU | MS SQL server - time taken for the previous exec of the job | ||
| 12 | MSQLSTRURE | MS SQL server - retry attempts of the last exec. of the job | ||
| 13 | MSQLSTRUST | MS SQL server - status of the previous exec. job step. | ||
| 14 | MSQLSTRUTI | MS SQL server - time of the job step's previous execution | ||
| 15 | MSQRETATTE | MS SQL server - retry attempts for the job or step | ||
| 16 | MSQRETINTE | MS SQL server - wait interval between retry attempts | ||
| 17 | MSQSUBSYS | MS SQL server - Name of the subsystem used for job execution | ||
| 18 | MSQSUCCACT | MS SQL server - action to be performed after job success | ||
| 19 | MSQSUCCCDE | MS SQL server - success code returned by cmdexe subsystem | ||
| 20 | MSQSUCSTID | MS SQL Server - next step ID in job after job step success |