Data Element list used by SAP ABAP Table MSQSCHEDUL (MS SQL server jobschedules ( as from msdb..sysjobschedules))
SAP ABAP Table
MSQSCHEDUL (MS SQL server jobschedules ( as from msdb..sysjobschedules)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | MSQJBSCHID | MS SQL server - schedule id of the job | ||
| 2 | MSQJOBID | MS SQL Server job ID | ||
| 3 | MSSACTEDAT | MS SQL Server task active end date | ||
| 4 | MSSACTSDAT | MS SQL Server task active start date | ||
| 5 | MSSACTSTOD | MS SQL Server task active start time of day | ||
| 6 | MSSACTSTOD | MS SQL Server task active start time of day | ||
| 7 | MSSCREDATE | MS SQL Server task creation date and time | ||
| 8 | MSSENABLED | MS SQL Server task enabled status bit | ||
| 9 | MSSFREQINT | MS SQL Server frequency interval | ||
| 10 | MSSFREQTYP | MS SQL Server task frequency type | ||
| 11 | MSSFRQRFAC | MS SQL Server task frequency recurrence factor | ||
| 12 | MSSFRQRINT | MS SQL Server frequency relative interval of a SQL task | ||
| 13 | MSSFRQSINT | MS SQL Server task frequency sub interval | ||
| 14 | MSSFRQSTYP | MS SQL Server frequency sub type of a SQL task | ||
| 15 | MSSNRUNDAT | MS SQL Server next task run date | ||
| 16 | MSSNRUNTIM | MS SQL Server next task run time | ||
| 17 | MSSTSKNAME | MS SQL Server task name |