SAP ABAP Table MSQSCHEDUL (MS SQL server jobschedules ( as from msdb..sysjobschedules))
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 | MSQSCHEDUL |
Table Relationship Diagram 
|
| Short Description | MS SQL server jobschedules ( as from msdb..sysjobschedules) |
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 |  SCHEDID |
MSQJBSCHID | INT4 | INT4 | 10 | 0 | MS SQL server - schedule id of the job | ||
| 2 | JOBID |
MSQJOBID | MSQHEX16 | RAW | 16 | 0 | MS SQL Server job ID | ||
| 3 | NAME |
MSSTSKNAME | CHAR | 128 | 0 | MS SQL Server task name | |||
| 4 | ENABLED |
MSSENABLED | INT1 | INT1 | 3 | 0 | MS SQL Server task enabled status bit | ||
| 5 | FREQTYPE |
MSSFREQTYP | INT4 | INT4 | 10 | 0 | MS SQL Server task frequency type | ||
| 6 | FREQINTER |
MSSFREQINT | INT4 | INT4 | 10 | 0 | MS SQL Server frequency interval | ||
| 7 | FREQSUBTYP |
MSSFRQSTYP | INT4 | INT4 | 10 | 0 | MS SQL Server frequency sub type of a SQL task | ||
| 8 | FREQSUBINT |
MSSFRQSINT | INT4 | INT4 | 10 | 0 | MS SQL Server task frequency sub interval | ||
| 9 | FREQRELINT |
MSSFRQRINT | INT4 | INT4 | 10 | 0 | MS SQL Server frequency relative interval of a SQL task | ||
| 10 | FREQRECFAC |
MSSFRQRFAC | INT4 | INT4 | 10 | 0 | MS SQL Server task frequency recurrence factor | ||
| 11 | ACTSTRTDAT |
MSSACTSDAT | INT4 | INT4 | 10 | 0 | MS SQL Server task active start date | ||
| 12 | ACTENDDATE |
MSSACTEDAT | INT4 | INT4 | 10 | 0 | MS SQL Server task active end date | ||
| 13 | ACTSTRTTOD |
MSSACTSTOD | INT4 | INT4 | 10 | 0 | MS SQL Server task active start time of day | ||
| 14 | ACTENDTTOD |
MSSACTSTOD | INT4 | INT4 | 10 | 0 | MS SQL Server task active start time of day | ||
| 15 | NEXTRUNDAT |
MSSNRUNDAT | INT4 | INT4 | 10 | 0 | MS SQL Server next task run date | ||
| 16 | NEXTRUNTIM |
MSSNRUNTIM | INT4 | INT4 | 10 | 0 | MS SQL Server next task run time | ||
| 17 | CREATEDATE |
MSSCREDATE | TEXT20 | CHAR | 20 | 0 | MS SQL Server task creation date and time |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
