SAP MSQ_JOBS table - MS SQL SERVER JOB description (as from msdb..sysjobs) details in SAP

  


SAP MSQ_JOBS table summary

Object Name: MSQ_JOBS
Dictionary Type: Structure
Description: MS SQL SERVER JOB description (as from msdb..sysjobs)


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

Details
MSQ_JOBS-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

MSQ_JOBS-SERVER table field - MS SQL Server server to be used for a SQL task execution ▼

Description: MS SQL Server server to be used for a SQL task execution
Field Name: SERVER
Data Element: MSSSERVER1
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SERVER

MSQ_JOBS-JOBNAME table field - MS SQL Server task name ▼

Description: MS SQL Server task name
Field Name: JOBNAME
Data Element: MSSTSKNAME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field JOBNAME

MSQ_JOBS-ENABLED table field - MS SQL Server task enabled status bit ▼

Description: MS SQL Server task enabled status bit
Field Name: ENABLED
Data Element: MSSENABLED
Data Type: INT1
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: INT1
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ENABLED

MSQ_JOBS-DESCRIPT table field - MS SQL Server task description ▼

Description: MS SQL Server task description
Field Name: DESCRIPT
Data Element: MSSDESC
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: TEXT255
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DESCRIPT

MSQ_JOBS-STARSTEPID table field - MS SQL server Start Step ID ▼

Description: MS SQL server Start Step ID
Field Name: STARSTEPID
Data Element: MSQSTEPID
Data Type: INT1
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: INT1
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STARSTEPID

MSQ_JOBS-CREATEDATE table field - MS SQL Server task creation date and time ▼

Description: MS SQL Server task creation date and time
Field Name: CREATEDATE
Data Element: MSSCREDATE
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATEDATE

MSQ_JOBS-MODIFYDATE table field - MS SQL Server task modification date and time ▼

Description: MS SQL Server task modification date and time
Field Name: MODIFYDATE
Data Element: MSSMODDATE
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MODIFYDATE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table