SAP ABAP Table MSSTASK (MS SQL Server task description (as from msdb..systasks))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-MSS (Application Component) Microsoft SQL Server
⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-MSS (Application Component) Microsoft SQL Server⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
| Table Category | INTTAB | Structure |
| Structure | MSSTASK |
Table Relationship Diagram 
|
| Short Description | MS SQL Server task description (as from msdb..systasks) |
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 |  TASKID |
MSSTASKID | INT4 | INT4 | 10 | 0 | MS SQL Server task identifier | ||
| 2 | TASKNAME |
MSSTSKNAME | CHAR | 128 | 0 | MS SQL Server task name | |||
| 3 | SUBSYSTEM |
MSSSUBSYST | TEXT30 | CHAR | 30 | 0 | MS SQL Server subsystem used for a SQL task | ||
| 4 | SERVER |
MSSSERVER_ | TEXT30 | CHAR | 30 | 0 | MS SQL Server server to be used for a SQL task execution | ||
| 5 | USERNAME |
MSSUNAME | TEXT30 | CHAR | 30 | 0 | MS SQL Server user name | ||
| 6 | OWNERLOGIN |
MSSLOGINID | INT2 | INT2 | 5 | 0 | MS SQL Server login ID | ||
| 7 | DBNAME |
MSSDDBNAME | TEXT30 | CHAR | 30 | 0 | MS SQL Server: Database name | ||
| 8 | ENABLED |
MSSENABLED | INT1 | INT1 | 3 | 0 | MS SQL Server task enabled status bit | ||
| 9 | FREQTYPE |
MSSFREQTYP | INT4 | INT4 | 10 | 0 | MS SQL Server task frequency type | ||
| 10 | FREQINTER |
MSSFREQINT | INT4 | INT4 | 10 | 0 | MS SQL Server frequency interval | ||
| 11 | FREQSUBTYP |
MSSFRQSTYP | INT4 | INT4 | 10 | 0 | MS SQL Server frequency sub type of a SQL task | ||
| 12 | FREQSUBINT |
MSSFRQSINT | INT4 | INT4 | 10 | 0 | MS SQL Server task frequency sub interval | ||
| 13 | FREQRELINT |
MSSFRQRINT | INT4 | INT4 | 10 | 0 | MS SQL Server frequency relative interval of a SQL task | ||
| 14 | FREQRECFAC |
MSSFRQRFAC | INT4 | INT4 | 10 | 0 | MS SQL Server task frequency recurrence factor | ||
| 15 | ACTSTRTDAT |
MSSACTSDAT | INT4 | INT4 | 10 | 0 | MS SQL Server task active start date | ||
| 16 | ACTENDDATE |
MSSACTEDAT | INT4 | INT4 | 10 | 0 | MS SQL Server task active end date | ||
| 17 | ACTSTRTTOD |
MSSACTSTOD | INT4 | INT4 | 10 | 0 | MS SQL Server task active start time of day | ||
| 18 | LASTRUNDAT |
MSSLRUNDAT | INT4 | INT4 | 10 | 0 | MS SQL Server last run date for SQL task | ||
| 19 | LASTRUNTIM |
MSSLRUNTIM | INT4 | INT4 | 10 | 0 | MS SQL Server last task run time | ||
| 20 | NEXTRUNDAT |
MSSNRUNDAT | INT4 | INT4 | 10 | 0 | MS SQL Server next task run date | ||
| 21 | NEXTRUNTIM |
MSSNRUNTIM | INT4 | INT4 | 10 | 0 | MS SQL Server next task run time | ||
| 22 | RUNPRIO |
MSSRUNPRIO | INT4 | INT4 | 10 | 0 | MS SQL Server task run priority | ||
| 23 | RETRYATTEM |
MSSRETRYAT | INT4 | INT4 | 10 | 0 | MS SQL Server task execution retry attempts | ||
| 24 | RETRYDELAY |
MSSRETRYDE | INT4 | INT4 | 10 | 0 | MS SQL Server task retry delay | ||
| 25 | CREATEDATE |
MSSCREDATE | TEXT20 | CHAR | 20 | 0 | MS SQL Server task creation date and time | ||
| 26 | MODIFYDATE |
MSSMODDATE | TEXT20 | CHAR | 20 | 0 | MS SQL Server task modification date and time | ||
| 27 | COMMAND |
MSSTASKCMD | TEXT255 | CHAR | 255 | 0 | MS SQL Server task command | ||
| 28 | LASTLEVEL |
MSSLASTLVL | INT4 | INT4 | 10 | 0 | MS SQL Server last task execution status | ||
| 29 | LASTDURATE |
MSSLASTDUR | INT4 | INT4 | 10 | 0 | MS SQL Server last task run duration | ||
| 30 | LASTNUMRET |
MSSLASTNRE | INT4 | INT4 | 10 | 0 | MS SQL Server number of retries for last execution | ||
| 31 | DESCRIPT |
MSSDESC | TEXT255 | CHAR | 255 | 0 | MS SQL Server task description |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
