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 | Data Element | MSQCATEID | MS SQL server - job category | |
2 | Data Element | MSQEVTNOT | MS SQL server - event log notification level | |
3 | Data Element | MSQJBDELEV | MS SQL server - job deletion status after the job execution | |
4 | Data Element | MSQJBVERNU | MS SQL server - version of the job | |
5 | Data Element | MSQJOBDESC | MS SQL server - description of the job | |
6 | Data Element | MSQJOBDTCR | MS SQL server - the date the job was created | |
7 | Data Element | MSQJOBDTMO | MS SQL server - the date the job was last modified | |
8 | Data Element | MSQJOBENA | MS SQL server - job enable status for execution | |
9 | Data Element | MSQJOBID | MS SQL Server job ID | |
10 | Data Element | MSQJOBNAME | MS SQl server - name of the job | |
11 | Data Element | MSQMAILNOT | MS sql server - email notification level | |
12 | Data Element | MSQMAIOPID | MS SQL Server - e-mail operator ID | |
13 | Data Element | MSQNETNOT | MS SQL server - network notification level | |
14 | Data Element | MSQNETOPID | ID of the system or user sending the message | |
15 | Data Element | MSQORISER | MS SQL server - job originating server | |
16 | Data Element | MSQOWNSID | MS SQL server - system iden. number (SID) of the job's owner | |
17 | Data Element | MSQPAGNOT | MS SQL server - page notification level | |
18 | Data Element | MSQPAGOPID | MSSQL - ID of computer or user used for sending a page | |
19 | Data Element | MSQSTJOBID | MS SQL Server - starting job step ID |