SAP ABAP Table MSQ_JOBS (MS SQL SERVER JOB description (as from msdb..sysjobs))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-MSS (Application Component) Microsoft SQL Server
⤷
SMSS_SQLJOBS (Package) Database Jobs for MS SQL Server
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-MSS (Application Component) Microsoft SQL Server⤷
SMSS_SQLJOBS (Package) Database Jobs for MS SQL Server
Basic Data
| Table Category | INTTAB | Structure |
| Structure | MSQ_JOBS |
Table Relationship Diagram 
|
| Short Description | MS SQL SERVER JOB description (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 | SERVER |
MSSSERVER1 | TEXT30 | CHAR | 30 | 0 | MS SQL Server server to be used for a SQL task execution | ||
| 3 | JOBNAME |
MSSTSKNAME | CHAR | 128 | 0 | MS SQL Server task name | |||
| 4 | ENABLED |
MSSENABLED | INT1 | INT1 | 3 | 0 | MS SQL Server task enabled status bit | ||
| 5 | DESCRIPT |
MSSDESC | TEXT255 | CHAR | 255 | 0 | MS SQL Server task description | ||
| 6 | STARSTEPID |
MSQSTEPID | INT1 | INT1 | 3 | 0 | MS SQL server Start Step ID | ||
| 7 | CREATEDATE |
MSSCREDATE | TEXT20 | CHAR | 20 | 0 | MS SQL Server task creation date and time | ||
| 8 | MODIFYDATE |
MSSMODDATE | TEXT20 | CHAR | 20 | 0 | MS SQL Server task modification date and time |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
