Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_SCHEDULER_JOB_DESTS

ALL_SCHEDULER_JOB_DESTS displays information about the state of the jobs accessible to the current user at each of their destinations.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(30)   Owner of the Scheduler job
JOB_NAME VARCHAR2(30)   Name of the Scheduler job
JOB_SUBNAME VARCHAR2(31)   Subname of the Scheduler job
CREDENTIAL_OWNER VARCHAR2(30)   Owner of the credential used for the remote destination
CREDENTIAL_NAME VARCHAR2(30)   Name of the credential used for the remote destination
DESTINATION_OWNER VARCHAR2(128)   Owner of the destination object that points to the destination
DESTINATION VARCHAR2(128)   Name of the destination object or the name of the destination itself
JOB_DEST_ID NUMBER   Numerical ID assigned to the job at this destination
ENABLED VARCHAR2(5)   Indicates whether the parent job is enabled (TRUE) or disabled (FALSE)
REFS_ENABLED VARCHAR2(5)   Indicates whether this destination and its agent are enabled (TRUE) or disabled (FALSE)
STATE VARCHAR2(15)   State of this job at this destination:
  • DISABLED

  • RUNNING

  • CHAIN_STALLED

  • SCHEDULED

  • RETRY SCHEDULED

  • READY TO RUN

  • COMPLETED

  • BROKEN

  • FAILED

  • SUCCEEDED

  • REMOTE

  • STOPPED

NEXT_START_DATE TIMESTAMP(6) WITH TIME ZONE   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   Last time this job started at this destination
LAST_END_DATE TIMESTAMP(6) WITH TIME ZONE   Last time this job ended at this destination