SAP ABAP Table MSQJBSHIS (MS SQL server Job History ( from msdb..sysjobhistory (7.0))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ SMSS_SQLJOBS (Package) Database Jobs for MS SQL Server

Basic Data

Table Category	INTTAB	Structure
Structure	MSQJBSHIS	Table Relationship Diagram
Short Description	MS SQL server Job History ( from msdb..sysjobhistory (7.0)

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	JOBID	☐			RAW	16	0
2	MSSTEPID	☐			INT1	3	0
3	MSGID	☐			INT4	10	0
4	SEVERITY	☐			INT4	10	0
5	MESSAGE1	☐			CHAR	255	0
6	STATUS	☐			INT4	10	0
7	RUNDATE	☐			INT4	10	0
8	RUNTIME	☐			INT4	10	0
9	RUNDURATE	☐			INT4	10	0
10	RETRIES	☐			INT4	10	0
11	ACTSTTIME	☐			INT4	10	0

History

Last changed by/on	SAP	20110908
SAP Release Created in