SAP ABAP Table MSSSCHJOBS (List of sql agent jobs scheduled for the next X days)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-DB-MSS (Application Component) Microsoft SQL Server
     SMSS_SQLJOBS (Package) Database Jobs for MS SQL Server
Basic Data
Table Category INTTAB    Structure 
Structure MSSSCHJOBS   Table Relationship Diagram
Short Description List of sql agent jobs scheduled for the next X days    
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 JOB_NAME MSQJOBNAME CHAR100 CHAR 100   0   MS SQl server - name of the job  
2 NEXTRUNDT MSSNXRNDT   DATS 8   0   Sql agent job - Next run Date  
3 NEXTRUNTM MSSNXRNTM   TIMS 6   0   SQL Agent Job's Next Run Time  
4 LASTRUNDUR MSQLSTRUDU INT4 INT4 10   0   MS SQL server - time taken for the previous exec of the job  
5 LSTRUNSTUS MSQLSTRUST INT4 INT4 10   0   MS SQL server - status of the previous exec. job step.  
6 STATUSDESC MSSSTADESC   CHAR 25   0   Sql Agent Job status description  
7 SCHEDESC MSSSCHDESC   CHAR 25   0   Sql Agent Job scheule Information  
8 JOB_CLASS MSSJBCLASS   CHAR 25   0   Sql Agent Job class(type)  
9 LSTRUNDATE MSSLSTRNDT   DATS 8   0   Sql agent job - Last run Date  
10 LSTRUNTIME MSSLSTRNTM   TIMS 6   0   Agent job's last run time  
11 JOB_DESC MSQJOBDESC   CHAR 255   0   MS SQL server - description of the job  
12 JOBCOMMAND MSQJOBCMD CHAR520 CHAR 520   0   MS SQL server - command executed by the subsytem  
13 JOB_OWNER MSQUNAME CHAR30 CHAR 30   0   Database user name/ Owner of sql agent job  
14 DBNAME MSSDB MSSSYSNAME CHAR 128   0   Database name  
15 ENABLED MSQJOBENA INT2 INT2 5   0   MS SQL server - job enable status for execution  
16 JOB_ID MSQJOBID MSQHEX16 RAW 16   0   MS SQL Server job ID  
History
Last changed by/on SAP  20130604 
SAP Release Created in 620