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 | ![]() |
MSSACTEDAT | MS SQL Server task active end date | |
2 | ![]() |
MSSACTSDAT | MS SQL Server task active start date | |
3 | ![]() |
MSSACTSTOD | MS SQL Server task active start time of day | |
4 | ![]() |
MSSCREDATE | MS SQL Server task creation date and time | |
5 | ![]() |
MSSDDBNAME | MS SQL Server: Database name | |
6 | ![]() |
MSSDESC | MS SQL Server task description | |
7 | ![]() |
MSSENABLED | MS SQL Server task enabled status bit | |
8 | ![]() |
MSSFREQINT | MS SQL Server frequency interval | |
9 | ![]() |
MSSFREQTYP | MS SQL Server task frequency type | |
10 | ![]() |
MSSFRQRFAC | MS SQL Server task frequency recurrence factor | |
11 | ![]() |
MSSFRQRINT | MS SQL Server frequency relative interval of a SQL task | |
12 | ![]() |
MSSFRQSINT | MS SQL Server task frequency sub interval | |
13 | ![]() |
MSSFRQSTYP | MS SQL Server frequency sub type of a SQL task | |
14 | ![]() |
MSSLASTDUR | MS SQL Server last task run duration | |
15 | ![]() |
MSSLASTLVL | MS SQL Server last task execution status | |
16 | ![]() |
MSSLASTNRE | MS SQL Server number of retries for last execution | |
17 | ![]() |
MSSLOGINID | MS SQL Server login ID | |
18 | ![]() |
MSSLRUNDAT | MS SQL Server last run date for SQL task | |
19 | ![]() |
MSSLRUNTIM | MS SQL Server last task run time | |
20 | ![]() |
MSSMODDATE | MS SQL Server task modification date and time | |
21 | ![]() |
MSSNRUNDAT | MS SQL Server next task run date | |
22 | ![]() |
MSSNRUNTIM | MS SQL Server next task run time | |
23 | ![]() |
MSSRETRYAT | MS SQL Server task execution retry attempts | |
24 | ![]() |
MSSRETRYDE | MS SQL Server task retry delay | |
25 | ![]() |
MSSRUNPRIO | MS SQL Server task run priority | |
26 | ![]() |
MSSSERVER_ | MS SQL Server server to be used for a SQL task execution | |
27 | ![]() |
MSSSUBSYST | MS SQL Server subsystem used for a SQL task | |
28 | ![]() |
MSSTASKCMD | MS SQL Server task command | |
29 | ![]() |
MSSTASKID | MS SQL Server task identifier | |
30 | ![]() |
MSSTSKNAME | MS SQL Server task name | |
31 | ![]() |
MSSUNAME | MS SQL Server user name |