SAP ABAP Table MSSCCMSSNGLJB (Information on a single job)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Table Category	INTTAB	Structure
Structure	MSSCCMSSNGLJB	Table Relationship Diagram
Short Description	Information on a single job

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	MS SQL server list of CCMS planned tasks
2	JOB_NAME	☐	MSQJOBNAME	CHAR100	CHAR	100	0	MS SQl server - name of the job
3	OWNER	☐	MSQUNAME	CHAR30	CHAR	30	0	Database user name/ Owner of sql agent job
4	DBNAME	☐	MSSDB	MSSSYSNAME	CHAR	128	0	Database name
5	JOBTYPE	☐	MSQSUBSYS	CHAR60	CHAR	60	0	MS SQL server - Name of the subsystem used for job execution
6	COMMAND	☐	MSQJOBCMD	CHAR520	CHAR	520	0	MS SQL server - command executed by the subsytem
7	RUNDATE	☐	MSQBEGRUDT		DATS	8	0	MS SQL server - the date to begin executing the job
8	RUNTIME	☐	MSQBEGRUTM		TIMS	6	0	MS SQL server - the time to start executing the server job
9	RUNSTATUS	☐	MSQJOBSTAT	INT4	INT4	10	0	MS SQL server - the status of the job's execution
10	LSTRUNDATE	☐	MSSLSTRNDT		DATS	8	0	Sql agent job - Last run Date
11	LSTRUNTIME	☐	MSSLSTRNTM		TIMS	6	0	Agent job's last run time
12	NEXTRUNTM	☐	MSSNXRNTM		TIMS	6	0	SQL Agent Job's Next Run Time
13	NEXTRUNDT	☐	MSSNXRNDT		DATS	8	0	Sql agent job - Next run Date
14	JOBID	☐	MSQJOBID	MSQHEX16	RAW	16	0	MS SQL Server job ID
15	ENABLED	☐	MSQJOBENA	INT2	INT2	5	0	MS SQL server - job enable status for execution
16	STATUSDESC	☐	MSSSTADESC		CHAR	25	0	Sql Agent Job status description
17	SCHEDTYPE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
18	WEEKDAY	☐	INT1	INT1	INT1	3	0	Dummy for B20 int1 (Local Everywhere)

History

Last changed by/on	SAP	20130604
SAP Release Created in	710