eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TYPE: SYS.JOB_DEFINITION

Object Details

Object Name:	JOB_DEFINITION
Object Type:	TYPE
Owner:	SYS
Subobject Name:	$VSN_1
Status:	VALID

Object Details

Object Name:	JOB_DEFINITION
Object Type:	TYPE
Owner:	SYS
Subobject Name:	$VSN_2
Status:	VALID

Object Details

Object Name:	JOB_DEFINITION
Object Type:	TYPE
Owner:	SYS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length	Prcn
JOB_NAME	VARCHAR2	(100)
JOB_CLASS	VARCHAR2	(32)
JOB_STYLE	VARCHAR2	(17)
PROGRAM_NAME	VARCHAR2	(100)
JOB_ACTION	VARCHAR2	(4000)
JOB_TYPE	VARCHAR2	(20)
SCHEDULE_NAME	VARCHAR2	(65)
REPEAT_INTERVAL	VARCHAR2	(4000)
SCHEDULE_LIMIT	INTERVAL DAY TO SECOND		2
START_DATE	TIMESTAMP WITH TZ
END_DATE	TIMESTAMP WITH TZ
EVENT_CONDITION	VARCHAR2	(4000)
QUEUE_SPEC	VARCHAR2	(100)
NUMBER_OF_ARGUMENTS	NUMBER
ARGUMENTS	JOBARG_ARRAY
JOB_PRIORITY	NUMBER
JOB_WEIGHT	NUMBER
MAX_RUN_DURATION	INTERVAL DAY TO SECOND		2
MAX_RUNS	NUMBER
MAX_FAILURES	NUMBER
LOGGING_LEVEL	NUMBER
RESTARTABLE	VARCHAR2	(5)
STOP_ON_WINDOW_CLOSE	VARCHAR2	(5)
RAISE_EVENTS	NUMBER
COMMENTS	VARCHAR2	(240)
AUTO_DROP	VARCHAR2	(5)
ENABLED	VARCHAR2	(5)
FOLLOW_DEFAULT_TIMEZONE	VARCHAR2	(5)
PARALLEL_INSTANCES	VARCHAR2	(5)
AQ_JOB	VARCHAR2	(5)
INSTANCE_ID	NUMBER
CREDENTIAL_NAME	VARCHAR2	(65)
DESTINATION	VARCHAR2	(4000)
DATABASE_ROLE	VARCHAR2	(20)
ALLOW_RUNS_IN_RESTRICTED_MODE	VARCHAR2	(5)
RESTART_ON_RECOVERY	VARCHAR2	(5)
RESTART_ON_FAILURE	VARCHAR2	(5)
CONNECT_CREDENTIAL_NAME	VARCHAR2	(65)
STORE_OUTPUT	VARCHAR2	(5)

Methods

Name	Parameters	Result
JOB_DEFINITION	SELF(JOB_DEFINITION) JOB_NAME(VARCHAR2) JOB_STYLE(VARCHAR2) PROGRAM_NAME(VARCHAR2) JOB_ACTION(VARCHAR2) JOB_TYPE(VARCHAR2) SCHEDULE_NAME(VARCHAR2) REPEAT_INTERVAL(VARCHAR2) EVENT_CONDITION(VARCHAR2) QUEUE_SPEC(VARCHAR2) START_DATE(TIMESTAMP WITH TZ) END_DATE(TIMESTAMP WITH TZ) NUMBER_OF_ARGUMENTS(PL/SQL BINARY INTEGER) ARGUMENTS(JOBARG_ARRAY) JOB_CLASS(VARCHAR2) SCHEDULE_LIMIT(INTERVAL DAY TO SECOND) JOB_PRIORITY(PL/SQL BINARY INTEGER) JOB_WEIGHT(PL/SQL BINARY INTEGER) MAX_RUN_DURATION(INTERVAL DAY TO SECOND) MAX_RUNS(PL/SQL BINARY INTEGER) MAX_FAILURES(PL/SQL BINARY INTEGER) LOGGING_LEVEL(PL/SQL BINARY INTEGER) RESTARTABLE(PL/SQL BOOLEAN) STOP_ON_WINDOW_CLOSE(PL/SQL BOOLEAN) RAISE_EVENTS(PL/SQL BINARY INTEGER) COMMENTS(VARCHAR2) AUTO_DROP(PL/SQL BOOLEAN) ENABLED(PL/SQL BOOLEAN) FOLLOW_DEFAULT_TIMEZONE(PL/SQL BOOLEAN) PARALLEL_INSTANCES(PL/SQL BOOLEAN) AQ_JOB(PL/SQL BOOLEAN) INSTANCE_ID(PL/SQL BINARY INTEGER) CREDENTIAL_NAME(VARCHAR2) DESTINATION(VARCHAR2) DATABASE_ROLE(VARCHAR2) ALLOW_RUNS_IN_RESTRICTED_MODE(PL/SQL BOOLEAN) RESTART_ON_RECOVERY(PL/SQL BOOLEAN) RESTART_ON_FAILURE(PL/SQL BOOLEAN) CONNECT_CREDENTIAL_NAME(VARCHAR2) STORE_OUTPUT(PL/SQL BOOLEAN)	JOB_DEFINITION

Dependencies

[top of page]

SYS.JOB_DEFINITION references the following:

SYS: JOBARG_ARRAY; STANDARD - show dependent code

SYS.JOB_DEFINITION is referenced by following:

PUBLIC: JOB_DEFINITION
SYS: DBMS_I_INDEX_UTL - show dependent code; DBMS_SCHEDULER - show dependent code; DBMS_SNAPSHOT - show dependent code; JOB; JOB_DEFINITION; JOB_DEFINITION_ARRAY; UTL_RECOMP - show dependent code