SAP ABAP Table MSQJOBSTEP (MS SQL server jobsteps ( as from msdb..sysjobsteps))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects
⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
Table Category | INTTAB | Structure |
Structure | MSQJOBSTEP | Table Relationship Diagram |
Short Description | MS SQL server jobsteps ( as from msdb..sysjobsteps) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | JOBID | MSQJOBID | MSQHEX16 | RAW | 16 | 0 | MS SQL Server job ID | ||
2 | STEPID | MSQJBSTPID | INT4 | INT4 | 10 | 0 | MS SQL Server - the ID of the step in the job | ||
3 | STEPNAME | MSQJBSTPNA | CHAR100 | CHAR | 100 | 0 | MS SQL server - the name of the step | ||
4 | SUBSYSTEM | MSQSUBSYS | CHAR60 | CHAR | 60 | 0 | MS SQL server - Name of the subsystem used for job execution | ||
5 | JOBCOMMAND | MSQJOBCMD | CHAR520 | CHAR | 520 | 0 | MS SQL server - command executed by the subsytem | ||
6 | SUCCESSCDE | MSQSUCCCDE | INT4 | INT4 | 10 | 0 | MS SQL server - success code returned by cmdexe subsystem | ||
7 | SUCCESSACT | MSQSUCCACT | INT2 | INT2 | 5 | 0 | MS SQL server - action to be performed after job success | ||
8 | SUCCESSSTP | MSQSUCSTID | INT4 | INT4 | 10 | 0 | MS SQL Server - next step ID in job after job step success | ||
9 | FAILACT | MSQFAIACT | INT2 | INT2 | 5 | 0 | MSSQL Server - action to be performed after job step failure | ||
10 | FAILSTP | MSQFAISTID | INT4 | INT4 | 10 | 0 | MS SQL server - next step after the failure of job step | ||
11 | DBASENAME | MSQJBDNAME | CHAR64 | CHAR | 64 | 0 | MS SQL server - name of the database in which job is exec. | ||
12 | DBASEUNAME | MSQJBUNAME | CHAR64 | CHAR | 64 | 0 | MS SQL server - name of db user executing the step | ||
13 | RETRY | MSQRETATTE | INT4 | INT4 | 10 | 0 | MS SQL server - retry attempts for the job or step | ||
14 | RETRYINT | MSQRETINTE | INT4 | INT4 | 10 | 0 | MS SQL server - wait interval between retry attempts | ||
15 | OUTPUTFILE | MSQJBOUTFL | CHAR255 | CHAR | 255 | 0 | MS SQL server - the name of the job step's output file | ||
16 | LSTRUNSTA | MSQLSTRUST | INT4 | INT4 | 10 | 0 | MS SQL server - status of the previous exec. job step. | ||
17 | LSTRUNDU | MSQLSTRUDU | INT4 | INT4 | 10 | 0 | MS SQL server - time taken for the previous exec of the job | ||
18 | LSTRUNRET | MSQLSTRURE | INT4 | INT4 | 10 | 0 | MS SQL server - retry attempts of the last exec. of the job | ||
19 | LSTRUNDT | MSQLSTRUDT | INT4 | INT4 | 10 | 0 | MS SQL server - date of the job step's prev execution | ||
20 | LSTRUNTI | MSQLSTRUTI | INT4 | INT4 | 10 | 0 | MS SQL server - time of the job step's previous execution |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |