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 | Data Element | MSQJBSCHID | MS SQL server - schedule id of the job | |
2 | Data Element | MSQJOBID | MS SQL Server job ID | |
3 | Data Element | MSSACTEDAT | MS SQL Server task active end date | |
4 | Data Element | MSSACTSDAT | MS SQL Server task active start date | |
5 | Data Element | MSSACTSTOD | MS SQL Server task active start time of day | |
6 | Data Element | MSSACTSTOD | MS SQL Server task active start time of day | |
7 | Data Element | MSSCREDATE | MS SQL Server task creation date and time | |
8 | Data Element | MSSENABLED | MS SQL Server task enabled status bit | |
9 | Data Element | MSSFREQINT | MS SQL Server frequency interval | |
10 | Data Element | MSSFREQTYP | MS SQL Server task frequency type | |
11 | Data Element | MSSFRQRFAC | MS SQL Server task frequency recurrence factor | |
12 | Data Element | MSSFRQRINT | MS SQL Server frequency relative interval of a SQL task | |
13 | Data Element | MSSFRQSINT | MS SQL Server task frequency sub interval | |
14 | Data Element | MSSFRQSTYP | MS SQL Server frequency sub type of a SQL task | |
15 | Data Element | MSSNRUNDAT | MS SQL Server next task run date | |
16 | Data Element | MSSNRUNTIM | MS SQL Server next task run time | |
17 | Data Element | MSSTSKNAME | MS SQL Server task name |