Data Element list used by SAP ABAP Table MSQCCMSJOB (MS SQL server list of CCMS planned tasks)
SAP ABAP Table MSQCCMSJOB (MS SQL server list of CCMS planned tasks) is using
# | Object Type | Object Name | Object Description | Note |
---|---|---|---|---|
1 | Data Element | MSQBEGRUDT | MS SQL server - the date to begin executing the job | |
2 | Data Element | MSQBEGRUTM | MS SQL server - the time to start executing the server job | |
3 | Data Element | MSQJOBCMD | MS SQL server - command executed by the subsytem | |
4 | Data Element | MSQJOBENA | MS SQL server - job enable status for execution | |
5 | Data Element | MSQJOBID | MS SQL Server job ID | |
6 | Data Element | MSQJOBNAME | MS SQl server - name of the job | |
7 | Data Element | MSQJOBSTAT | MS SQL server - the status of the job's execution | |
8 | Data Element | MSQSUBSYS | MS SQL server - Name of the subsystem used for job execution | |
9 | Data Element | MSQUNAME | Database user name/ Owner of sql agent job | |
10 | Data Element | MSSDB | Database name | |
11 | Data Element | MSSLSTRNDT | Sql agent job - Last run Date | |
12 | Data Element | MSSLSTRNTM | Agent job's last run time | |
13 | Data Element | MSSNXRNDT | Sql agent job - Next run Date | |
14 | Data Element | MSSNXRNTM | SQL Agent Job's Next Run Time | |
15 | Data Element | MSSSTADESC | Sql Agent Job status description |