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

  • DBA_SCHEDULER_JOB_DESTS displays information about the state of all jobs in the database at each of their destinations.

  • USER_SCHEDULER_JOB_DESTS displays information about the state of the jobs owned by the current user at each of their destinations. This view does not display the OWNER column.

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