SAP MSQSCHEDUL table - MS SQL server jobschedules ( as from msdb..sysjobschedules) details in SAP


SAP MSQSCHEDUL table summary

Object Name: MSQSCHEDUL
Dictionary Type: Structure
Description: MS SQL server jobschedules ( as from msdb..sysjobschedules)


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

Details
MSQSCHEDUL-SCHEDID table field - MS SQL server - schedule id of the job

Description: MS SQL server - schedule id of the job
Field Name: SCHEDID
Data Element: MSQJBSCHID
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 SCHEDID

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

MSQSCHEDUL-NAME table field - MS SQL Server task name

Description: MS SQL Server task name
Field Name: NAME
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 NAME

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

MSQSCHEDUL-FREQTYPE table field - MS SQL Server task frequency type

Description: MS SQL Server task frequency type
Field Name: FREQTYPE
Data Element: MSSFREQTYP
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 FREQTYPE

MSQSCHEDUL-FREQINTER table field - MS SQL Server frequency interval

Description: MS SQL Server frequency interval
Field Name: FREQINTER
Data Element: MSSFREQINT
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 FREQINTER

MSQSCHEDUL-FREQSUBTYP table field - MS SQL Server frequency sub type of a SQL task

Description: MS SQL Server frequency sub type of a SQL task
Field Name: FREQSUBTYP
Data Element: MSSFRQSTYP
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 FREQSUBTYP

MSQSCHEDUL-FREQSUBINT table field - MS SQL Server task frequency sub interval

Description: MS SQL Server task frequency sub interval
Field Name: FREQSUBINT
Data Element: MSSFRQSINT
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 FREQSUBINT

MSQSCHEDUL-FREQRELINT table field - MS SQL Server frequency relative interval of a SQL task

Description: MS SQL Server frequency relative interval of a SQL task
Field Name: FREQRELINT
Data Element: MSSFRQRINT
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 FREQRELINT

MSQSCHEDUL-FREQRECFAC table field - MS SQL Server task frequency recurrence factor

Description: MS SQL Server task frequency recurrence factor
Field Name: FREQRECFAC
Data Element: MSSFRQRFAC
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 FREQRECFAC

MSQSCHEDUL-ACTSTRTDAT table field - MS SQL Server task active start date

Description: MS SQL Server task active start date
Field Name: ACTSTRTDAT
Data Element: MSSACTSDAT
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 ACTSTRTDAT

MSQSCHEDUL-ACTENDDATE table field - MS SQL Server task active end date

Description: MS SQL Server task active end date
Field Name: ACTENDDATE
Data Element: MSSACTEDAT
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 ACTENDDATE

MSQSCHEDUL-ACTSTRTTOD table field - MS SQL Server task active start time of day

Description: MS SQL Server task active start time of day
Field Name: ACTSTRTTOD
Data Element: MSSACTSTOD
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 ACTSTRTTOD

MSQSCHEDUL-ACTENDTTOD table field - MS SQL Server task active start time of day

Description: MS SQL Server task active start time of day
Field Name: ACTENDTTOD
Data Element: MSSACTSTOD
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 ACTENDTTOD

MSQSCHEDUL-NEXTRUNDAT table field - MS SQL Server next task run date

Description: MS SQL Server next task run date
Field Name: NEXTRUNDAT
Data Element: MSSNRUNDAT
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 NEXTRUNDAT

MSQSCHEDUL-NEXTRUNTIM table field - MS SQL Server next task run time

Description: MS SQL Server next task run time
Field Name: NEXTRUNTIM
Data Element: MSSNRUNTIM
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 NEXTRUNTIM

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


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table