SAP MSQJOBHIS table - MS SQL server job history ( as from msdb..sysjobhistory ) details in SAP


SAP MSQJOBHIS table summary

Object Name: MSQJOBHIS
Dictionary Type: Structure
Description: MS SQL server job history ( as from msdb..sysjobhistory )


Field list for MSQJOBHIS table on an S/4 SAP system

Details
MSQJOBHIS-INSTANCEID table field - MS SQL server - unique identifier for the job history row

Description: MS SQL server - unique identifier for the job history row
Field Name: INSTANCEID
Data Element: MSQJBINSID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INSTANCEID

MSQJOBHIS-JOBID table field - MS SQL Server job ID

Description: MS SQL Server job ID
Field Name: JOBID
Data Element: MSQJOBID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: MSQHEX16
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field JOBID

MSQJOBHIS-STEPID table field - MS SQL Server - the ID of the step in the job

Description: MS SQL Server - the ID of the step in the job
Field Name: STEPID
Data Element: MSQJBSTPID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STEPID

MSQJOBHIS-STEPNAME table field - MS SQL server - the name of the step

Description: MS SQL server - the name of the step
Field Name: STEPNAME
Data Element: MSQJBSTPNA
Data Type: CHAR
length (Dec): 100(0)
Check table:
Conversion Routine:
Domain Name: CHAR100
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STEPNAME

MSQJOBHIS-MESSAGEID table field - MS SQL Server - ID of the SQL error message

Description: MS SQL Server - ID of the SQL error message
Field Name: MESSAGEID
Data Element: MSQSQLMGID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MESSAGEID

MSQJOBHIS-SEVERITY table field - MS SQL server - the severity of the sql error message

Description: MS SQL server - the severity of the sql error message
Field Name: SEVERITY
Data Element: MSQSQLSEV
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEVERITY

MSQJOBHIS-MESSAGE table field - MS SQL server - sql error message

Description: MS SQL server - sql error message
Field Name: MESSAGE
Data Element: MSQSQLMSG
Data Type: CHAR
length (Dec): 1024(0)
Check table:
Conversion Routine:
Domain Name: MSQCH1024
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MESSAGE

MSQJOBHIS-RUNSTATUS table field - MS SQL server - the status of the job's execution

Description: MS SQL server - the status of the job's execution
Field Name: RUNSTATUS
Data Element: MSQJOBSTAT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RUNSTATUS

MSQJOBHIS-RUNDATE table field - MS SQL server - the date the job or step started execution.

Description: MS SQL server - the date the job or step started execution.
Field Name: RUNDATE
Data Element: MSQJBRUNDT
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RUNDATE

MSQJOBHIS-RUNTIME table field - MS SQL server - the time the job or step completed

Description: MS SQL server - the time the job or step completed
Field Name: RUNTIME
Data Element: MSQJBRUNTM
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RUNTIME

MSQJOBHIS-RUNDURA table field - MS SQL server - the duration of the job run

Description: MS SQL server - the duration of the job run
Field Name: RUNDURA
Data Element: MSQJBRUNDU
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RUNDURA

MSQJOBHIS-EMAILOPID table field - MS SQL Server - e-mail operator ID

Description: MS SQL Server - e-mail operator ID
Field Name: EMAILOPID
Data Element: MSQMAIOPID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMAILOPID

MSQJOBHIS-NETSENTID table field - ID of the system or user sending the message

Description: ID of the system or user sending the message
Field Name: NETSENTID
Data Element: MSQNETOPID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NETSENTID

MSQJOBHIS-PAGEDOPID table field - MSSQL - ID of computer or user used for sending a page

Description: MSSQL - ID of computer or user used for sending a page
Field Name: PAGEDOPID
Data Element: MSQPAGOPID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAGEDOPID

MSQJOBHIS-RETRIES table field - MS SQL server - retry attempts for the job or step

Description: MS SQL server - retry attempts for the job or step
Field Name: RETRIES
Data Element: MSQRETATTE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RETRIES

MSQJOBHIS-SERVER table field - MS SQL server - name of server where the job was executed

Description: MS SQL server - name of server where the job was executed
Field Name: SERVER
Data Element: MSQJBSERVR
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SERVER


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table