Data Element list used by SAP ABAP Table MSSSCHJOBS (List of sql agent jobs scheduled for the next X days)
SAP ABAP Table MSSSCHJOBS (List of sql agent jobs scheduled for the next X days) is using
# | Object Type | Object Name | Object Description | Note |
---|---|---|---|---|
1 | Data Element | MSQJOBCMD | MS SQL server - command executed by the subsytem | |
2 | Data Element | MSQJOBDESC | MS SQL server - description of the job | |
3 | Data Element | MSQJOBENA | MS SQL server - job enable status for execution | |
4 | Data Element | MSQJOBID | MS SQL Server job ID | |
5 | Data Element | MSQJOBNAME | MS SQl server - name of the job | |
6 | Data Element | MSQLSTRUDU | MS SQL server - time taken for the previous exec of the job | |
7 | Data Element | MSQLSTRUST | MS SQL server - status of the previous exec. job step. | |
8 | Data Element | MSQUNAME | Database user name/ Owner of sql agent job | |
9 | Data Element | MSSDB | Database name | |
10 | Data Element | MSSJBCLASS | Sql Agent Job class(type) | |
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 | MSSSCHDESC | Sql Agent Job scheule Information | |
16 | Data Element | MSSSTADESC | Sql Agent Job status description |