Data Element list used by SAP ABAP Table MSSTASK (MS SQL Server task description (as from msdb..systasks))
SAP ABAP Table MSSTASK (MS SQL Server task description (as from msdb..systasks)) is using
# | Object Type | Object Name | Object Description | Note |
---|---|---|---|---|
1 | Data Element | MSSACTEDAT | MS SQL Server task active end date | |
2 | Data Element | MSSACTSDAT | MS SQL Server task active start date | |
3 | Data Element | MSSACTSTOD | MS SQL Server task active start time of day | |
4 | Data Element | MSSCREDATE | MS SQL Server task creation date and time | |
5 | Data Element | MSSDDBNAME | MS SQL Server: Database name | |
6 | Data Element | MSSDESC | MS SQL Server task description | |
7 | Data Element | MSSENABLED | MS SQL Server task enabled status bit | |
8 | Data Element | MSSFREQINT | MS SQL Server frequency interval | |
9 | Data Element | MSSFREQTYP | MS SQL Server task frequency type | |
10 | Data Element | MSSFRQRFAC | MS SQL Server task frequency recurrence factor | |
11 | Data Element | MSSFRQRINT | MS SQL Server frequency relative interval of a SQL task | |
12 | Data Element | MSSFRQSINT | MS SQL Server task frequency sub interval | |
13 | Data Element | MSSFRQSTYP | MS SQL Server frequency sub type of a SQL task | |
14 | Data Element | MSSLASTDUR | MS SQL Server last task run duration | |
15 | Data Element | MSSLASTLVL | MS SQL Server last task execution status | |
16 | Data Element | MSSLASTNRE | MS SQL Server number of retries for last execution | |
17 | Data Element | MSSLOGINID | MS SQL Server login ID | |
18 | Data Element | MSSLRUNDAT | MS SQL Server last run date for SQL task | |
19 | Data Element | MSSLRUNTIM | MS SQL Server last task run time | |
20 | Data Element | MSSMODDATE | MS SQL Server task modification date and time | |
21 | Data Element | MSSNRUNDAT | MS SQL Server next task run date | |
22 | Data Element | MSSNRUNTIM | MS SQL Server next task run time | |
23 | Data Element | MSSRETRYAT | MS SQL Server task execution retry attempts | |
24 | Data Element | MSSRETRYDE | MS SQL Server task retry delay | |
25 | Data Element | MSSRUNPRIO | MS SQL Server task run priority | |
26 | Data Element | MSSSERVER_ | MS SQL Server server to be used for a SQL task execution | |
27 | Data Element | MSSSUBSYST | MS SQL Server subsystem used for a SQL task | |
28 | Data Element | MSSTASKCMD | MS SQL Server task command | |
29 | Data Element | MSSTASKID | MS SQL Server task identifier | |
30 | Data Element | MSSTSKNAME | MS SQL Server task name | |
31 | Data Element | MSSUNAME | MS SQL Server user name |