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
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