Data Element list used by SAP ABAP Table MSQJOBHIS (MS SQL server job history ( as from msdb..sysjobhistory ))
SAP ABAP Table 
MSQJOBHIS (MS SQL server job history ( as from msdb..sysjobhistory )) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
MSQJBINSID | MS SQL server - unique identifier for the job history row | |
| 2 | Data Element |
MSQJBRUNDT | MS SQL server - the date the job or step started execution. | |
| 3 | Data Element |
MSQJBRUNDU | MS SQL server - the duration of the job run | |
| 4 | Data Element |
MSQJBRUNTM | MS SQL server - the time the job or step completed | |
| 5 | Data Element |
MSQJBSERVR | MS SQL server - name of server where the job was executed | |
| 6 | Data Element |
MSQJBSTPID | MS SQL Server - the ID of the step in the job | |
| 7 | Data Element |
MSQJBSTPNA | MS SQL server - the name of the step | |
| 8 | Data Element |
MSQJOBID | MS SQL Server job ID | |
| 9 | Data Element |
MSQJOBSTAT | MS SQL server - the status of the job's execution | |
| 10 | Data Element |
MSQMAIOPID | MS SQL Server - e-mail operator ID | |
| 11 | Data Element |
MSQNETOPID | ID of the system or user sending the message | |
| 12 | Data Element |
MSQPAGOPID | MSSQL - ID of computer or user used for sending a page | |
| 13 | Data Element |
MSQRETATTE | MS SQL server - retry attempts for the job or step | |
| 14 | Data Element |
MSQSQLMGID | MS SQL Server - ID of the SQL error message | |
| 15 | Data Element |
MSQSQLMSG | MS SQL server - sql error message | |
| 16 | Data Element |
MSQSQLSEV | MS SQL server - the severity of the sql error message |
