DBA Data[Home] [Help]

VIEW: SYS.CDB_SCHEDULER_JOB_DESTS

Source

View Text - Preformatted

SELECT "OWNER","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","CON_ID" FROM CONTAINERS("SYS"."DBA_SCHEDULER_JOB_DESTS")
View Text - HTML Formatted

SELECT "OWNER"
, "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"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_SCHEDULER_JOB_DESTS")