SAP ABAP Table MSQSYSJOBS (MS SQL server list of jobs ( as from msdb..sysjobs))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-MSS (Application Component) Microsoft SQL Server
⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-MSS (Application Component) Microsoft SQL Server⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
| Table Category | INTTAB | Structure |
| Structure | MSQSYSJOBS |
Table Relationship Diagram 
|
| Short Description | MS SQL server list of jobs ( as from msdb..sysjobs) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  JOBID |
MSQJOBID | MSQHEX16 | RAW | 16 | 0 | MS SQL Server job ID | ||
| 2 | ORISERVER |
MSQORISER | CHAR30 | CHAR | 30 | 0 | MS SQL server - job originating server | ||
| 3 | JOBNAME |
MSQJOBNAME | CHAR100 | CHAR | 100 | 0 | MS SQl server - name of the job | ||
| 4 | ENABLED |
MSQJOBENA | INT2 | INT2 | 5 | 0 | MS SQL server - job enable status for execution | ||
| 5 | JOBDESC |
MSQJOBDESC | CHAR | 255 | 0 | MS SQL server - description of the job | |||
| 6 | STASTEPID |
MSQSTJOBID | INT4 | INT4 | 10 | 0 | MS SQL Server - starting job step ID | ||
| 7 | CATEGORY |
MSQCATEID | INT4 | INT4 | 10 | 0 | MS SQL server - job category | ||
| 8 | OWNERSID |
MSQOWNSID | MSQHEX85 | RAW | 85 | 0 | MS SQL server - system iden. number (SID) of the job's owner | ||
| 9 | NOTEVTLOG |
MSQEVTNOT | INT4 | INT4 | 10 | 0 | MS SQL server - event log notification level | ||
| 10 | NOTEMAIL |
MSQMAILNOT | INT4 | INT4 | 10 | 0 | MS sql server - email notification level | ||
| 11 | NOTNETSEND |
MSQNETNOT | INT4 | INT4 | 10 | 0 | MS SQL server - network notification level | ||
| 12 | NOTPAGE |
MSQPAGNOT | INT4 | INT4 | 10 | 0 | MS SQL server - page notification level | ||
| 13 | EMAILOPID |
MSQMAIOPID | INT4 | INT4 | 10 | 0 | MS SQL Server - e-mail operator ID | ||
| 14 | NETSNDOPID |
MSQNETOPID | INT4 | INT4 | 10 | 0 | ID of the system or user sending the message | ||
| 15 | PAGEOPID |
MSQPAGOPID | INT4 | INT4 | 10 | 0 | MSSQL - ID of computer or user used for sending a page | ||
| 16 | DELETELEV |
MSQJBDELEV | INT4 | INT4 | 10 | 0 | MS SQL server - job deletion status after the job execution | ||
| 17 | DATECRE |
MSQJOBDTCR | CHAR8 | CHAR | 8 | 0 | MS SQL server - the date the job was created | ||
| 18 | DATEMOD |
MSQJOBDTMO | CHAR8 | CHAR | 8 | 0 | MS SQL server - the date the job was last modified | ||
| 19 | VERNUMBER |
MSQJBVERNU | INT4 | INT4 | 10 | 0 | MS SQL server - version of the job |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
