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:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
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:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
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:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
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:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
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:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
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:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
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:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
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:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
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:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
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:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
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:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
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:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
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:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
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:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
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:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
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:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SERVER