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

Object Details

Object Name:	JOB
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	(11)
JOB_TEMPLATE	VARCHAR2	(100)
PROGRAM_ACTION	VARCHAR2	(4000)
ACTION_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_ARGS	NUMBER
ARGUMENTS	JOBARG_ARRAY
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_EXIT	VARCHAR2	(5)
RAISE_EVENTS	NUMBER
COMMENTS	VARCHAR2	(240)
AUTO_DROP	VARCHAR2	(5)
ENABLED	VARCHAR2	(5)
FOLLOW_DEFAULT_TZ	VARCHAR2	(5)
PARALLEL_INSTANCES	VARCHAR2	(5)
AQ_JOB	VARCHAR2	(5)
INSTANCE_ID	NUMBER

Methods

Name	Parameters	Result
JOB	SELF(JOB) JOB_NAME(VARCHAR2) JOB_STYLE(VARCHAR2) JOB_TEMPLATE(VARCHAR2) PROGRAM_ACTION(VARCHAR2) ACTION_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_ARGS(PL/SQL BINARY INTEGER) ARGUMENTS(JOBARG_ARRAY) JOB_CLASS(VARCHAR2) SCHEDULE_LIMIT(INTERVAL DAY TO SECOND) 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_EXIT(PL/SQL BOOLEAN) RAISE_EVENTS(PL/SQL BINARY INTEGER) COMMENTS(VARCHAR2) AUTO_DROP(PL/SQL BOOLEAN) ENABLED(PL/SQL BOOLEAN) FOLLOW_DEFAULT_TZ(PL/SQL BOOLEAN) PARALLEL_INSTANCES(PL/SQL BOOLEAN) AQ_JOB(PL/SQL BOOLEAN) INSTANCE_ID(PL/SQL BINARY INTEGER)	JOB

Dependencies

[top of page]

SYS.JOB references the following:

SYS: JOBARG_ARRAY; STANDARD - show dependent code

SYS.JOB is referenced by following:

PUBLIC: JOB
SYS: DBMS_SCHEDULER - show dependent code; JOB; JOB_ARRAY