SAP MSQSYSJOBS table - MS SQL server list of jobs ( as from msdb..sysjobs) details in SAP

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

Description: MS SQL server - job originating server
Field Name: ORISERVER
Data Element: MSQORISER
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 ORISERVER

Description: MS SQl server - name of the job
Field Name: JOBNAME
Data Element: MSQJOBNAME
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 JOBNAME

Description: MS SQL server - job enable status for execution
Field Name: ENABLED
Data Element: MSQJOBENA
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ENABLED

Description: MS SQL server - description of the job
Field Name: JOBDESC
Data Element: MSQJOBDESC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field JOBDESC

Description: MS SQL Server - starting job step ID
Field Name: STASTEPID
Data Element: MSQSTJOBID
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 STASTEPID

Description: MS SQL server - job category
Field Name: CATEGORY
Data Element: MSQCATEID
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 CATEGORY

Description: MS SQL server - system iden. number (SID) of the job's owner
Field Name: OWNERSID
Data Element: MSQOWNSID
Data Type: RAW
length (Dec): 85(0)
Check table:
Conversion Routine:
Domain Name: MSQHEX85
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OWNERSID

Description: MS SQL server - event log notification level
Field Name: NOTEVTLOG
Data Element: MSQEVTNOT
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 NOTEVTLOG

Description: MS sql server - email notification level
Field Name: NOTEMAIL
Data Element: MSQMAILNOT
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 NOTEMAIL

Description: MS SQL server - network notification level
Field Name: NOTNETSEND
Data Element: MSQNETNOT
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 NOTNETSEND

Description: MS SQL server - page notification level
Field Name: NOTPAGE
Data Element: MSQPAGNOT
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 NOTPAGE

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

Description: ID of the system or user sending the message
Field Name: NETSNDOPID
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 NETSNDOPID

Description: MSSQL - ID of computer or user used for sending a page
Field Name: PAGEOPID
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 PAGEOPID

Description: MS SQL server - job deletion status after the job execution
Field Name: DELETELEV
Data Element: MSQJBDELEV
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 DELETELEV

Description: MS SQL server - the date the job was created
Field Name: DATECRE
Data Element: MSQJOBDTCR
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATECRE

Description: MS SQL server - the date the job was last modified
Field Name: DATEMOD
Data Element: MSQJOBDTMO
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATEMOD

Description: MS SQL server - version of the job
Field Name: VERNUMBER
Data Element: MSQJBVERNU
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 VERNUMBER