MSQJOBSTEP SAP (MS SQL server jobsteps ( as from msdb..sysjobsteps)) Structure details

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




ABAP Code to SELECT data from MSQJOBSTEP
Related tables to MSQJOBSTEP
Access table MSQJOBSTEP




Structure field list including key, data, relationships and ABAP select examples

MSQJOBSTEP is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "MS SQL server jobsteps ( as from msdb..sysjobsteps)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_MSQJOBSTEP TYPE MSQJOBSTEP.

The MSQJOBSTEP table consists of various fields, each holding specific information or linking keys about MS SQL server jobsteps ( as from msdb..sysjobsteps) data available in SAP. These include STEPID (MS SQL Server - the ID of the step in the job), STEPNAME (MS SQL server - the name of the step), SUBSYSTEM (MS SQL server - Name of the subsystem used for job execution), JOBCOMMAND (MS SQL server - command executed by the subsytem).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP MSQJOBSTEP structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
JOBIDMS SQL Server job ID MSQJOBIDRAW16MSQHEX16
STEPIDMS SQL Server - the ID of the step in the job MSQJBSTPIDINT410INT4
STEPNAMEMS SQL server - the name of the step MSQJBSTPNACHAR100CHAR100
SUBSYSTEMMS SQL server - Name of the subsystem used for job execution MSQSUBSYSCHAR60CHAR60
JOBCOMMANDMS SQL server - command executed by the subsytem MSQJOBCMDCHAR520CHAR520
SUCCESSCDEMS SQL server - success code returned by cmdexe subsystem MSQSUCCCDEINT410INT4
SUCCESSACTMS SQL server - action to be performed after job success MSQSUCCACTINT25INT2
SUCCESSSTPMS SQL Server - next step ID in job after job step success MSQSUCSTIDINT410INT4
FAILACTMSSQL Server - action to be performed after job step failure MSQFAIACTINT25INT2
FAILSTPMS SQL server - next step after the failure of job step MSQFAISTIDINT410INT4
DBASENAMEMS SQL server - name of the database in which job is exec. MSQJBDNAMECHAR64CHAR64
DBASEUNAMEMS SQL server - name of db user executing the step MSQJBUNAMECHAR64CHAR64
RETRYMS SQL server - retry attempts for the job or step MSQRETATTEINT410INT4
RETRYINTMS SQL server - wait interval between retry attempts MSQRETINTEINT410INT4
OUTPUTFILEMS SQL server - the name of the job step's output file MSQJBOUTFLCHAR255CHAR255
LSTRUNSTAMS SQL server - status of the previous exec. job step. MSQLSTRUSTINT410INT4
LSTRUNDUMS SQL server - time taken for the previous exec of the job MSQLSTRUDUINT410INT4
LSTRUNRETMS SQL server - retry attempts of the last exec. of the job MSQLSTRUREINT410INT4
LSTRUNDTMS SQL server - date of the job step's prev execution MSQLSTRUDTINT410INT4
LSTRUNTIMS SQL server - time of the job step's previous execution MSQLSTRUTIINT410INT4

Key field Non-key field



How do I retrieve data from SAP structure MSQJOBSTEP using ABAP code?

As MSQJOBSTEP is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MSQJOBSTEP as there is no data to select.

How to access SAP table MSQJOBSTEP

Within an ECC or HANA version of SAP you can also view further information about MSQJOBSTEP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!