SAP ABAP Table MSQJOBHIS (MS SQL server job history ( as from msdb..sysjobhistory ))
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 | MSQJOBHIS |
Table Relationship Diagram 
|
| Short Description | MS SQL server job history ( as from msdb..sysjobhistory ) |
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 |  INSTANCEID |
MSQJBINSID | INT4 | INT4 | 10 | 0 | MS SQL server - unique identifier for the job history row | ||
| 2 | JOBID |
MSQJOBID | MSQHEX16 | RAW | 16 | 0 | MS SQL Server job ID | ||
| 3 | STEPID |
MSQJBSTPID | INT4 | INT4 | 10 | 0 | MS SQL Server - the ID of the step in the job | ||
| 4 | STEPNAME |
MSQJBSTPNA | CHAR100 | CHAR | 100 | 0 | MS SQL server - the name of the step | ||
| 5 | MESSAGEID |
MSQSQLMGID | INT4 | INT4 | 10 | 0 | MS SQL Server - ID of the SQL error message | ||
| 6 | SEVERITY |
MSQSQLSEV | INT4 | INT4 | 10 | 0 | MS SQL server - the severity of the sql error message | ||
| 7 | MESSAGE |
MSQSQLMSG | MSQCH1024 | CHAR | 1024 | 0 | MS SQL server - sql error message | ||
| 8 | RUNSTATUS |
MSQJOBSTAT | INT4 | INT4 | 10 | 0 | MS SQL server - the status of the job's execution | ||
| 9 | RUNDATE |
MSQJBRUNDT | INT4 | INT4 | 10 | 0 | MS SQL server - the date the job or step started execution. | ||
| 10 | RUNTIME |
MSQJBRUNTM | INT4 | INT4 | 10 | 0 | MS SQL server - the time the job or step completed | ||
| 11 | RUNDURA |
MSQJBRUNDU | INT4 | INT4 | 10 | 0 | MS SQL server - the duration of the job run | ||
| 12 | EMAILOPID |
MSQMAIOPID | INT4 | INT4 | 10 | 0 | MS SQL Server - e-mail operator ID | ||
| 13 | NETSENTID |
MSQNETOPID | INT4 | INT4 | 10 | 0 | ID of the system or user sending the message | ||
| 14 | PAGEDOPID |
MSQPAGOPID | INT4 | INT4 | 10 | 0 | MSSQL - ID of computer or user used for sending a page | ||
| 15 | RETRIES |
MSQRETATTE | INT4 | INT4 | 10 | 0 | MS SQL server - retry attempts for the job or step | ||
| 16 | SERVER |
MSQJBSERVR | CHAR30 | CHAR | 30 | 0 | MS SQL server - name of server where the job was executed |
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in |
