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 | MSQJOBCMD | MS SQL server - command executed by the subsytem | ||
| 2 | MSQJOBDESC | MS SQL server - description of the job | ||
| 3 | MSQJOBENA | MS SQL server - job enable status for execution | ||
| 4 | MSQJOBID | MS SQL Server job ID | ||
| 5 | MSQJOBNAME | MS SQl server - name of the job | ||
| 6 | MSQLSTRUDU | MS SQL server - time taken for the previous exec of the job | ||
| 7 | MSQLSTRUST | MS SQL server - status of the previous exec. job step. | ||
| 8 | MSQUNAME | Database user name/ Owner of sql agent job | ||
| 9 | MSSDB | Database name | ||
| 10 | MSSJBCLASS | Sql Agent Job class(type) | ||
| 11 | MSSLSTRNDT | Sql agent job - Last run Date | ||
| 12 | MSSLSTRNTM | Agent job's last run time | ||
| 13 | MSSNXRNDT | Sql agent job - Next run Date | ||
| 14 | MSSNXRNTM | SQL Agent Job's Next Run Time | ||
| 15 | MSSSCHDESC | Sql Agent Job scheule Information | ||
| 16 | MSSSTADESC | Sql Agent Job status description |