SAP ABAP Table MSSTASKHIS (MS SQL Server task history (parts from msdb..syshistory))
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 | MSSTASKHIS |
Table Relationship Diagram 
|
| Short Description | MS SQL Server task history (parts from msdb..syshistory) |
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 | MSGID |
MSSMSGID | INT4 | INT4 | 10 | 0 | MS SQL Server message ID | ||
| 3 | SEVERITY |
MSSSEVERE | INT4 | INT4 | 10 | 0 | MS SQL Server severity | ||
| 4 | STATUS |
MSSTSKSTAT | INT4 | INT4 | 10 | 0 | MS SQL Server task run status | ||
| 5 | RUNDATE |
MSSTSKRDAT | INT4 | INT4 | 10 | 0 | MS SQL Server task run date | ||
| 6 | RUNTIME |
MSSTSKRTIM | INT4 | INT4 | 10 | 0 | MS SQL Server task runtime | ||
| 7 | RUNDURATE |
MSSTSKDURA | INT4 | INT4 | 10 | 0 | MS SQL Server task run duration | ||
| 8 | RETRIES |
MSSRETRIES | INT4 | INT4 | 10 | 0 | MS SQL Server task execution retries | ||
| 9 | NUMSKIPPED |
MSSNUMSKIP | INT4 | INT4 | 10 | 0 | MS SQL Server number of task skips | ||
| 10 | COMMENTS |
MSSCOMMENT | TEXT255 | CHAR | 255 | 0 | MS SQL Server task execution comments |
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in |
