SAP ABAP Table MSQCCMSJOB (MS SQL server list of CCMS planned tasks)
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 MSQCCMSJOB   Table Relationship Diagram
Short Description MS SQL server list of CCMS planned tasks    
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 OWNER MSQUNAME CHAR30 CHAR 30   0   Database user name/ Owner of sql agent job  
3 DBNAME MSSDB MSSSYSNAME CHAR 128   0   Database name  
4 JOBTYPE MSQSUBSYS CHAR60 CHAR 60   0   MS SQL server - Name of the subsystem used for job execution  
5 COMMAND MSQJOBCMD CHAR520 CHAR 520   0   MS SQL server - command executed by the subsytem  
6 RUNDATE MSQBEGRUDT   DATS 8   0   MS SQL server - the date to begin executing the job  
7 RUNTIME MSQBEGRUTM   TIMS 6   0   MS SQL server - the time to start executing the server job  
8 RUNSTATUS MSQJOBSTAT INT4 INT4 10   0   MS SQL server - the status of the job's execution  
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 NEXTRUNTM MSSNXRNTM   TIMS 6   0   SQL Agent Job's Next Run Time  
12 NEXTRUNDT MSSNXRNDT   DATS 8   0   Sql agent job - Next run Date  
13 JOBID MSQJOBID MSQHEX16 RAW 16   0   MS SQL Server job ID  
14 ENABLED MSQJOBENA INT2 INT2 5   0   MS SQL server - job enable status for execution  
15 STATUSDESC MSSSTADESC   CHAR 25   0   Sql Agent Job status description  
History
Last changed by/on SAP  20130604 
SAP Release Created in