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:
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:
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:
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:
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:
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:
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: