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.USER_SCHEDULER_JOB_DESTS

Object Details

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

State of all jobs owned by current user at each of their destinations

[View Source]

Columns

Name	Datatype	Length	Comments
JOB_NAME	VARCHAR2	(128)	Name of scheduler job
JOB_SUBNAME	VARCHAR2	(128)	Subname of scheduler job
CREDENTIAL_OWNER	VARCHAR2	(128)	Owner of credential used for remote destination
CREDENTIAL_NAME	VARCHAR2	(128)	Name of credential used for remote destination
DESTINATION_OWNER	VARCHAR2	(128)	Owner of destination object that points to destination
DESTINATION	VARCHAR2	(128)	Name of destination object or name of destination itself
JOB_DEST_ID	NUMBER		Numerical ID assigned to job at this destination
ENABLED	VARCHAR2	(5)	Is this job enabled at this destination
REFS_ENABLED	VARCHAR2	(5)
STATE	VARCHAR2	(15)	State of this job at this destination
NEXT_START_DATE	TIMESTAMP(6) WITH TIME ZONE	(20)	Next start time of this job at this destination
RUN_COUNT	NUMBER		Number of times this job has run at this destination
RETRY_COUNT	NUMBER		Number of times this job has been retried at this destination
FAILURE_COUNT	NUMBER		Number of times this job has failed at this destination
LAST_START_DATE	TIMESTAMP(6) WITH TIME ZONE	(20)	Last time this job started at this destination
LAST_END_DATE	TIMESTAMP(6) WITH TIME ZONE	(20)	Last time this job ended at this destination

Query Text

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


SELECT JOB_NAME
,      JOB_SUBNAME
,      CREDENTIAL_OWNER
,      CREDENTIAL_NAME
,      DESTINATION_OWNER
,      DESTINATION
,      JOB_DEST_ID
,      ENABLED
,      REFS_ENABLED
,      STATE
,      NEXT_START_DATE
,      RUN_COUNT
,      RETRY_COUNT
,      FAILURE_COUNT
,      LAST_START_DATE
,      LAST_END_DATE
FROM SYS.USER_SCHEDULER_JOB_DESTS;

Dependencies

[top of page]

SYS.USER_SCHEDULER_JOB_DESTS references the following:

SYS: ALL_SCHEDULER_DB_DESTS; ALL_SCHEDULER_EXTERNAL_DESTS; OBJ$; SCHEDULER$_COMB_LW_JOB; SCHEDULER$_DESTINATIONS; SCHEDULER$_JOB; SCHEDULER$_LWJOB_OBJ; SCHEDULER$_WINDOW_GROUP; SCHEDULER$_WINGRP_MEMBER; USER$

SYS.USER_SCHEDULER_JOB_DESTS is referenced by following:

PUBLIC: USER_SCHEDULER_JOB_DESTS
SYS: USER_SCHEDULER_JOBS