SAP ABAP Table AGS_JOB_DEF (Definition of a Background Job)

Hierarchy

☛ ST (Software Component) SAP Solution Manager Tool
   ⤷ SV-SMG-PSM (Application Component) Process Scheduling Management
     ⤷ AGS_EXTJOB_REPOSITORY (Package) Job Scheduling Management Main Package

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	AGS_JOB_DEF	Table Relationship Diagram
Short Description	Definition of a Background Job

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	DEFINITION_ID	☑	AGS_EJR_JOB_DEFINITION_ID	SYSUUID_C	CHAR	32	0	Unique ID of a Job Definition
2	VERSION	☑	AGS_EJR_VERSION		NUMC	10	0	Job Documentation Version
3	SCHEDULER_TYPE	☐	AGS_EJR_SCHEDULER_TYPE	AGS_EJR_SCHEDULER_TYPE	CHAR	3	0	Scheduler Type
4	JOB_NAME	☐	AGS_EJR_JOB_NAME	AGS_EJR_JOB_NAME_DOM	CHAR	128	0	Job Documentation Name
5	JOB_TYPE	☐	AGS_EJR_STEP_TYPE_CODE	AGS_EJR_STEP_TYPE_CODE_DOM	CHAR	80	0	Job Types in SAP Solution Manager	*
6	JOB_TYPE_DEF	☐	AGS_EJR_JOBDOC_TYPE	AGS_EJR_JOBDOC_TYPE	CHAR	80	0	Documentation Type
7	JOB_STATUS	☐	AGS_EJR_STATUS	AGS_EJR_STATUS_DOM	CHAR	10	0	Documentation Status
8	JOB_STEP_ID	☐	AGS_EJR_IDENTIFIER	SYSUUID_C	CHAR	32	0	Unique ID	AGS_JOB_STEP
9	CONTEXT_ID	☐	AGS_EJR_IDENTIFIER	SYSUUID_C	CHAR	32	0	Unique ID	AGS_BUSNSS_CONT
10	LINK_ID	☐	AGS_EJR_IDENTIFIER	SYSUUID_C	CHAR	32	0	Unique ID	AGS_JOB_LINK
11	INSTANCE_ID	☐	AGS_EJR_IDENTIFIER	SYSUUID_C	CHAR	32	0	Unique ID	AGS_JOB_INSTANCE
12	MONITORING_ID	☐	AGS_EJR_IDENTIFIER	SYSUUID_C	CHAR	32	0	Unique ID	AGS_PARAM_MON
13	PARTNER_ID	☐	AGS_EJR_IDENTIFIER	SYSUUID_C	CHAR	32	0	Unique ID	AGS_PARTNER
14	ESCALATION_ID	☐	AGS_EJR_IDENTIFIER	SYSUUID_C	CHAR	32	0	Unique ID	AGS_ESCALATION
15	ERRORHANDLING_ID	☐	AGS_EJR_IDENTIFIER	SYSUUID_C	CHAR	32	0	Unique ID	AGS_ERRORHANDLNG
16	.INCLUDE	☐				0	0	Time and User of Last Processing
17	CREATED_BY	☐	AGS_EJR_USER	SYCHAR12	CHAR	12	0	User Name
18	CREATED_ON	☐	AGS_EJR_TIME_STAMP	TZNTSTMPL	DEC	21	7	Time Stamp
19	CHANGED_BY	☐	AGS_EJR_USER	SYCHAR12	CHAR	12	0	User Name
20	CHANGED_ON	☐	AGS_EJR_TIME_STAMP	TZNTSTMPL	DEC	21	7	Time Stamp
21	RESTRICTION_ID	☐	AGS_EJR_IDENTIFIER	SYSUUID_C	CHAR	32	0	Unique ID
22	VALID_UNTIL	☐	AGS_EJR_DUE_DATE	SYDATS	DATS	8	0	Due Date
23	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
24	AUTHORIZATION_ID	☐	AGS_EJR_IDENTIFIER	SYSUUID_C	CHAR	32	0	Unique ID
25	EXTERNAL_ID	☐	AGS_EJR_IDENTIFIER	SYSUUID_C	CHAR	32	0	Unique ID
26	LIFECYCLE_USAGE	☐	AGS_EJR_IDENTIFIER	SYSUUID_C	CHAR	32	0	Unique ID
27	JOBDOC_TYPE	☐	AGS_EJR_DOC_TYPE	AGS_EJR_DOC_TYPE	CHAR	1	0	Document Type for Display
28	JOBREQ_TYPE	☐	AGS_EJR_JOB_REQUEST_TYPE_ID	AGS_EJR_JOB_REQUEST_TYPE_ID	CHAR	3	0	Request Type: value = 'NEW', 'EDT', 'DEL'

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AGS_JOB_DEF	CONTEXT_ID	AGS_BUSNSS_CONT	CONTEXT_ID
2	AGS_JOB_DEF	ERRORHANDLING_ID	AGS_ERRORHANDLNG	ERRORHANDLING_ID
3	AGS_JOB_DEF	ESCALATION_ID	AGS_ESCALATION	ESCALATION_ID
4	AGS_JOB_DEF	INSTANCE_ID	AGS_JOB_INSTANCE	INSTANCE_ID
5	AGS_JOB_DEF	JOB_STEP_ID	AGS_JOB_STEP	STEP_ID
6	AGS_JOB_DEF	LINK_ID	AGS_JOB_LINK	LINK_ID
7	AGS_JOB_DEF	MONITORING_ID	AGS_PARAM_MON	MONITORING_ID
8	AGS_JOB_DEF	PARTNER_ID	AGS_PARTNER	PARTNER_ID

History

Last changed by/on	SAP	20111123
SAP Release Created in	400