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]

VIEW: SYS.DBA_SCHEDULER_JOBS

Object Details

Object Name:	DBA_SCHEDULER_JOBS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

All scheduler jobs in the database

[View Source]

Columns

Name	Datatype	Length	Comments
OWNER	VARCHAR2	(128)	Owner of the scheduler job
JOB_NAME	VARCHAR2	(128)	Name of the scheduler job
JOB_SUBNAME	VARCHAR2	(128)	Subname of the scheduler job (for a job running a chain step)
JOB_STYLE	VARCHAR2	(17)	Job style - regular, lightweight or volatile
JOB_CREATOR	VARCHAR2	(128)	Original creator of this job
CLIENT_ID	VARCHAR2	(65)	Client id of user creating job
GLOBAL_UID	VARCHAR2	(33)	Global uid of user creating this job
PROGRAM_OWNER	VARCHAR2	(4000)	Owner of the program associated with the job
PROGRAM_NAME	VARCHAR2	(4000)	Name of the program associated with the job
JOB_TYPE	VARCHAR2	(16)	Inlined job action type
JOB_ACTION	VARCHAR2	(4000)	Inlined job action
NUMBER_OF_ARGUMENTS	NUMBER		Inlined job number of arguments
SCHEDULE_OWNER	VARCHAR2	(4000)	Owner of the schedule that this job uses (can be a window or window group)
SCHEDULE_NAME	VARCHAR2	(4000)	Name of the schedule that this job uses (can be a window or window group)
SCHEDULE_TYPE	VARCHAR2	(12)	Type of the schedule that this job uses
START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)	Original scheduled start date of this job (for an inlined schedule)
REPEAT_INTERVAL	VARCHAR2	(4000)	Inlined schedule PL/SQL expression or calendar string
EVENT_QUEUE_OWNER	VARCHAR2	(128)	Owner of source queue into which event will be raised
EVENT_QUEUE_NAME	VARCHAR2	(128)	Name of source queue into which event will be raised
EVENT_QUEUE_AGENT	VARCHAR2	(256)	Name of AQ agent used by user on the event source queue (if it is a secure queue)
EVENT_CONDITION	VARCHAR2	(4000)	Boolean expression used as subscription rule for event on the source queue
EVENT_RULE	VARCHAR2	(261)	Name of rule used by the coordinator to trigger event based job
FILE_WATCHER_OWNER	VARCHAR2	(261)	Owner of file watcher on which this job is based
FILE_WATCHER_NAME	VARCHAR2	(261)	Name of file watcher on which this job is based
END_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)	Date after which this job will no longer run (for an inlined schedule)
JOB_CLASS	VARCHAR2	(128)	Name of job class associated with the job
ENABLED	VARCHAR2	(5)	Whether the job is enabled
AUTO_DROP	VARCHAR2	(5)	Whether this job will be dropped when it has completed
RESTART_ON_RECOVERY	VARCHAR2	(5)	Whether this job can be restarted after a db crash
RESTART_ON_FAILURE	VARCHAR2	(5)	Whether this job can be re-tried if it fails
STATE	VARCHAR2	(15)	Current state of the job
JOB_PRIORITY	NUMBER		Priority of the job relative to others within the same class
RUN_COUNT	NUMBER		Number of times this job has run
MAX_RUNS	NUMBER		Maximum number of times this job is scheduled to run
FAILURE_COUNT	NUMBER		Number of times this job has failed to run
MAX_FAILURES	NUMBER		Number of times this job will be allowed to fail before being marked broken
RETRY_COUNT	NUMBER		Number of times this job has retried, if it is retrying.
LAST_START_DATE	TIMESTAMP(6) WITH TIME ZONE	(20)	Last date on which the job started running
LAST_RUN_DURATION	INTERVAL DAY(9) TO SECOND(6)	(11)	How long the job took last time
NEXT_RUN_DATE	TIMESTAMP(6) WITH TIME ZONE	(20)	Next date the job is scheduled to run on
SCHEDULE_LIMIT	INTERVAL DAY(3) TO SECOND(0)	(11)	Time in minutes after which a job which has not run yet will be rescheduled
MAX_RUN_DURATION	INTERVAL DAY(3) TO SECOND(0)	(11)	This column is reserved for future use
LOGGING_LEVEL	VARCHAR2	(11)	Amount of logging that will be done pertaining to this job
STORE_OUTPUT	VARCHAR2	(5)	Determines if full job output is to be stored
STOP_ON_WINDOW_CLOSE	VARCHAR2	(5)	Whether this job will stop if a window it is associated with closes
INSTANCE_STICKINESS	VARCHAR2	(5)	Whether this job is sticky
RAISE_EVENTS	VARCHAR2	(4000)	List of job events to raise for this job
SYSTEM	VARCHAR2	(5)	Whether this is a system job
JOB_WEIGHT	NUMBER		Weight of this job
NLS_ENV	VARCHAR2	(4000)	NLS environment of this job
SOURCE	VARCHAR2	(128)	Source global database identifier
NUMBER_OF_DESTINATIONS	NUMBER
DESTINATION_OWNER	VARCHAR2	(128)	Owner of destination object (if used) else NULL
DESTINATION	VARCHAR2	(128)	Destination that this job will run on
CREDENTIAL_OWNER	VARCHAR2	(128)	Owner of login credential
CREDENTIAL_NAME	VARCHAR2	(128)	Name of login credential
INSTANCE_ID	NUMBER		Instance user requests job to run on.
DEFERRED_DROP	VARCHAR2	(5)	Whether this job will be dropped when completed due to user request.
ALLOW_RUNS_IN_RESTRICTED_MODE	VARCHAR2	(5)
COMMENTS	VARCHAR2	(240)	Comments on the job
FLAGS	NUMBER		This column is for internal use.
RESTARTABLE	VARCHAR2	(5)	Whether this job can be restarted or not
CONNECT_CREDENTIAL_OWNER	VARCHAR2	(128)	Owner of connect credential
CONNECT_CREDENTIAL_NAME	VARCHAR2	(128)	Name of connect credential

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      JOB_NAME
,      JOB_SUBNAME
,      JOB_STYLE
,      JOB_CREATOR
,      CLIENT_ID
,      GLOBAL_UID
,      PROGRAM_OWNER
,      PROGRAM_NAME
,      JOB_TYPE
,      JOB_ACTION
,      NUMBER_OF_ARGUMENTS
,      SCHEDULE_OWNER
,      SCHEDULE_NAME
,      SCHEDULE_TYPE
,      START_DATE
,      REPEAT_INTERVAL
,      EVENT_QUEUE_OWNER
,      EVENT_QUEUE_NAME
,      EVENT_QUEUE_AGENT
,      EVENT_CONDITION
,      EVENT_RULE
,      FILE_WATCHER_OWNER
,      FILE_WATCHER_NAME
,      END_DATE
,      JOB_CLASS
,      ENABLED
,      AUTO_DROP
,      RESTART_ON_RECOVERY
,      RESTART_ON_FAILURE
,      STATE
,      JOB_PRIORITY
,      RUN_COUNT
,      MAX_RUNS
,      FAILURE_COUNT
,      MAX_FAILURES
,      RETRY_COUNT
,      LAST_START_DATE
,      LAST_RUN_DURATION
,      NEXT_RUN_DATE
,      SCHEDULE_LIMIT
,      MAX_RUN_DURATION
,      LOGGING_LEVEL
,      STORE_OUTPUT
,      STOP_ON_WINDOW_CLOSE
,      INSTANCE_STICKINESS
,      RAISE_EVENTS
,      SYSTEM
,      JOB_WEIGHT
,      NLS_ENV
,      SOURCE
,      NUMBER_OF_DESTINATIONS
,      DESTINATION_OWNER
,      DESTINATION
,      CREDENTIAL_OWNER
,      CREDENTIAL_NAME
,      INSTANCE_ID
,      DEFERRED_DROP
,      ALLOW_RUNS_IN_RESTRICTED_MODE
,      COMMENTS
,      FLAGS
,      RESTARTABLE
,      CONNECT_CREDENTIAL_OWNER
,      CONNECT_CREDENTIAL_NAME
FROM SYS.DBA_SCHEDULER_JOBS;

Dependencies

[top of page]

SYS.DBA_SCHEDULER_JOBS references the following:

SYS: DBA_SCHEDULER_JOB_DESTS; DBMS_SCHEDULER - show dependent code; OBJ$; SCHEDULER$_COMB_LW_JOB; SCHEDULER$_JOB; SCHEDULER$_LWJOB_OBJ; USER$

SYS.DBA_SCHEDULER_JOBS is referenced by following:

PUBLIC: DBA_SCHEDULER_JOBS
SYS: DBA_AUTOTASK_CLIENT_JOB; DBA_AUTOTASK_TASK; DBA_XDS_ACL_REFRESH; DBMS_APPLY_ADM_INTERNAL - show dependent code; DBMS_AUTO_TASK_EXPORT - show dependent code; DBMS_FEATURE_JOB_SCHEDULER - show dependent code; DBMS_FILE_GROUP_UTL - show dependent code; DBMS_ISCHED - show dependent code; DBMS_I_INDEX_UTL - show dependent code; DBMS_PRVTAQIP - show dependent code; DBMS_QOPATCH - show dependent code; DBMS_SCHED_MAIN_EXPORT - show dependent code; DBMS_SNAPSHOT - show dependent code; DBMS_STREAMS_SM - show dependent code; PRVT_ILM - show dependent code; UTL_RECOMP - show dependent code; _DBA_STREAMS_COMPONENT_STAT; _DBA_SXGG_SPLIT_MERGE