Data Element list used by SAP ABAP Table MSQSYSJOBS (MS SQL server list of jobs ( as from msdb..sysjobs))
SAP ABAP Table
MSQSYSJOBS (MS SQL server list of jobs ( as from msdb..sysjobs)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | MSQCATEID | MS SQL server - job category | ||
| 2 | MSQEVTNOT | MS SQL server - event log notification level | ||
| 3 | MSQJBDELEV | MS SQL server - job deletion status after the job execution | ||
| 4 | MSQJBVERNU | MS SQL server - version of the job | ||
| 5 | MSQJOBDESC | MS SQL server - description of the job | ||
| 6 | MSQJOBDTCR | MS SQL server - the date the job was created | ||
| 7 | MSQJOBDTMO | MS SQL server - the date the job was last modified | ||
| 8 | MSQJOBENA | MS SQL server - job enable status for execution | ||
| 9 | MSQJOBID | MS SQL Server job ID | ||
| 10 | MSQJOBNAME | MS SQl server - name of the job | ||
| 11 | MSQMAILNOT | MS sql server - email notification level | ||
| 12 | MSQMAIOPID | MS SQL Server - e-mail operator ID | ||
| 13 | MSQNETNOT | MS SQL server - network notification level | ||
| 14 | MSQNETOPID | ID of the system or user sending the message | ||
| 15 | MSQORISER | MS SQL server - job originating server | ||
| 16 | MSQOWNSID | MS SQL server - system iden. number (SID) of the job's owner | ||
| 17 | MSQPAGNOT | MS SQL server - page notification level | ||
| 18 | MSQPAGOPID | MSSQL - ID of computer or user used for sending a page | ||
| 19 | MSQSTJOBID | MS SQL Server - starting job step ID |