SAP MSSSCHJOBS table - List of sql agent jobs scheduled for the next X days details in SAP

SAP MSSSCHJOBS table summary

Object Name: MSSSCHJOBS
Dictionary Type: Structure
Description: List of sql agent jobs scheduled for the next X days

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

Details

MSSSCHJOBS-JOB_NAME table field - MS SQl server - name of the job ▼

Description: MS SQl server - name of the job
Field Name: JOB_NAME
Data Element: MSQJOBNAME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field JOB_NAME

MSSSCHJOBS-NEXTRUNDT table field - Sql agent job - Next run Date ▼

Description: Sql agent job - Next run Date
Field Name: NEXTRUNDT
Data Element: MSSNXRNDT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NEXTRUNDT

MSSSCHJOBS-NEXTRUNTM table field - SQL Agent Job's Next Run Time ▼

Description: SQL Agent Job's Next Run Time
Field Name: NEXTRUNTM
Data Element: MSSNXRNTM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NEXTRUNTM

MSSSCHJOBS-LASTRUNDUR table field - MS SQL server - time taken for the previous exec of the job ▼

Description: MS SQL server - time taken for the previous exec of the job
Field Name: LASTRUNDUR
Data Element: MSQLSTRUDU
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LASTRUNDUR

MSSSCHJOBS-LSTRUNSTUS table field - MS SQL server - status of the previous exec. job step. ▼

Description: MS SQL server - status of the previous exec. job step.
Field Name: LSTRUNSTUS
Data Element: MSQLSTRUST
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LSTRUNSTUS

MSSSCHJOBS-STATUSDESC table field - Sql Agent Job status description ▼

Description: Sql Agent Job status description
Field Name: STATUSDESC
Data Element: MSSSTADESC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUSDESC

MSSSCHJOBS-SCHEDESC table field - Sql Agent Job scheule Information ▼

Description: Sql Agent Job scheule Information
Field Name: SCHEDESC
Data Element: MSSSCHDESC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCHEDESC

MSSSCHJOBS-JOB_CLASS table field - Sql Agent Job class(type) ▼

Description: Sql Agent Job class(type)
Field Name: JOB_CLASS
Data Element: MSSJBCLASS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field JOB_CLASS

MSSSCHJOBS-LSTRUNDATE table field - Sql agent job - Last run Date ▼

Description: Sql agent job - Last run Date
Field Name: LSTRUNDATE
Data Element: MSSLSTRNDT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LSTRUNDATE

MSSSCHJOBS-LSTRUNTIME table field - Agent job's last run time ▼

Description: Agent job's last run time
Field Name: LSTRUNTIME
Data Element: MSSLSTRNTM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LSTRUNTIME

MSSSCHJOBS-JOB_DESC table field - MS SQL server - description of the job ▼

Description: MS SQL server - description of the job
Field Name: JOB_DESC
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 JOB_DESC

MSSSCHJOBS-JOBCOMMAND table field - MS SQL server - command executed by the subsytem ▼

Description: MS SQL server - command executed by the subsytem
Field Name: JOBCOMMAND
Data Element: MSQJOBCMD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field JOBCOMMAND

MSSSCHJOBS-JOB_OWNER table field - Database user name/ Owner of sql agent job ▼

Description: Database user name/ Owner of sql agent job
Field Name: JOB_OWNER
Data Element: MSQUNAME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field JOB_OWNER

MSSSCHJOBS-DBNAME table field - Database name ▼

Description: Database name
Field Name: DBNAME
Data Element: MSSDB
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

MSSSCHJOBS-ENABLED table field - MS SQL server - job enable status for execution ▼

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

See all SAP tables containing field ENABLED

MSSSCHJOBS-JOB_ID table field - MS SQL Server job ID ▼

Description: MS SQL Server job ID
Field Name: JOB_ID
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 JOB_ID