SAP MSSTASK table - MS SQL Server task description (as from msdb..systasks) details in SAP

SAP MSSTASK table summary

Object Name: MSSTASK
Dictionary Type: Structure
Description: MS SQL Server task description (as from msdb..systasks)

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

Details

MSSTASK-TASKID table field - MS SQL Server task identifier ▼

Description: MS SQL Server task identifier
Field Name: TASKID
Data Element: MSSTASKID
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 TASKID

MSSTASK-TASKNAME table field - MS SQL Server task name ▼

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

MSSTASK-SUBSYSTEM table field - MS SQL Server subsystem used for a SQL task ▼

Description: MS SQL Server subsystem used for a SQL task
Field Name: SUBSYSTEM
Data Element: MSSSUBSYST
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 SUBSYSTEM

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

MSSTASK-USERNAME table field - MS SQL Server user name ▼

Description: MS SQL Server user name
Field Name: USERNAME
Data Element: MSSUNAME
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 USERNAME

MSSTASK-OWNERLOGIN table field - MS SQL Server login ID ▼

Description: MS SQL Server login ID
Field Name: OWNERLOGIN
Data Element: MSSLOGINID
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 OWNERLOGIN

MSSTASK-DBNAME table field - MS SQL Server: Database name ▼

Description: MS SQL Server: Database name
Field Name: DBNAME
Data Element: MSSDDBNAME
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 DBNAME

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

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

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

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

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

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

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

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

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

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

MSSTASK-LASTRUNDAT table field - MS SQL Server last run date for SQL task ▼

Description: MS SQL Server last run date for SQL task
Field Name: LASTRUNDAT
Data Element: MSSLRUNDAT
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 LASTRUNDAT

MSSTASK-LASTRUNTIM table field - MS SQL Server last task run time ▼

Description: MS SQL Server last task run time
Field Name: LASTRUNTIM
Data Element: MSSLRUNTIM
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 LASTRUNTIM

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

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

MSSTASK-RUNPRIO table field - MS SQL Server task run priority ▼

Description: MS SQL Server task run priority
Field Name: RUNPRIO
Data Element: MSSRUNPRIO
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 RUNPRIO

MSSTASK-RETRYATTEM table field - MS SQL Server task execution retry attempts ▼

Description: MS SQL Server task execution retry attempts
Field Name: RETRYATTEM
Data Element: MSSRETRYAT
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 RETRYATTEM

MSSTASK-RETRYDELAY table field - MS SQL Server task retry delay ▼

Description: MS SQL Server task retry delay
Field Name: RETRYDELAY
Data Element: MSSRETRYDE
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 RETRYDELAY

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

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

MSSTASK-COMMAND table field - MS SQL Server task command ▼

Description: MS SQL Server task command
Field Name: COMMAND
Data Element: MSSTASKCMD
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 COMMAND

MSSTASK-LASTLEVEL table field - MS SQL Server last task execution status ▼

Description: MS SQL Server last task execution status
Field Name: LASTLEVEL
Data Element: MSSLASTLVL
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 LASTLEVEL

MSSTASK-LASTDURATE table field - MS SQL Server last task run duration ▼

Description: MS SQL Server last task run duration
Field Name: LASTDURATE
Data Element: MSSLASTDUR
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 LASTDURATE

MSSTASK-LASTNUMRET table field - MS SQL Server number of retries for last execution ▼

Description: MS SQL Server number of retries for last execution
Field Name: LASTNUMRET
Data Element: MSSLASTNRE
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 LASTNUMRET

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

View list of all SAP tables(S4H/ECC)

Select data from SAP table