VIEW: SYS.SCHEDULER$_CDB_JOB

Source

View Text - Preformatted

SELECT "OBJ#","PROGRAM_OID","PROGRAM_ACTION","SCHEDULE_EXPR","QUEUE_OWNER","QUEUE_NAME","QUEUE_AGENT","EVENT_RULE","SCHEDULE_LIMIT","SCHEDULE_ID","START_DATE","END_DATE","LAST_ENABLED_TIME","CLASS_OID","PRIORITY","JOB_WEIGHT","NUMBER_OF_ARGS","MAX_RUNS","MAX_FAILURES","MAX_RUN_DURATION","MXDUR_MSGID","FLAGS","COMMENTS","USER_CALLBACK","USER_CALLBACK_CTX","CREATOR","CLIENT_ID","GUID","NLS_ENV","ENV","CHAR_ENV","SOURCE","DESTINATION","JOB_STATUS","NEXT_RUN_DATE","LAST_START_DATE","LAST_END_DATE","RETRY_COUNT","RUN_COUNT","FAILURE_COUNT","RUNNING_INSTANCE","RUNNING_SLAVE","DATABASE_ROLE","INSTANCE_ID","DIST_FLAGS","OWNER_UDN","CREDENTIAL_NAME","CREDENTIAL_OWNER","CREDENTIAL_OID","FW_NAME","FW_OID","DEST_OID","JOB_DEST_ID","RUN_INVOKER","CONNECT_CREDENTIAL_NAME","CONNECT_CREDENTIAL_OWNER","CONNECT_CREDENTIAL_OID","PDB_ID","CON_ID" FROM CONTAINERS("SYS"."SCHEDULER$_JOB")

View Text - HTML Formatted

SELECT "OBJ#"
, "PROGRAM_OID"
, "PROGRAM_ACTION"
, "SCHEDULE_EXPR"
, "QUEUE_OWNER"
, "QUEUE_NAME"
, "QUEUE_AGENT"
, "EVENT_RULE"
, "SCHEDULE_LIMIT"
, "SCHEDULE_ID"
, "START_DATE"
, "END_DATE"
, "LAST_ENABLED_TIME"
, "CLASS_OID"
, "PRIORITY"
, "JOB_WEIGHT"
, "NUMBER_OF_ARGS"
, "MAX_RUNS"
, "MAX_FAILURES"
, "MAX_RUN_DURATION"
, "MXDUR_MSGID"
, "FLAGS"
, "COMMENTS"
, "USER_CALLBACK"
, "USER_CALLBACK_CTX"
, "CREATOR"
, "CLIENT_ID"
, "GUID"
, "NLS_ENV"
, "ENV"
, "CHAR_ENV"
, "SOURCE"
, "DESTINATION"
, "JOB_STATUS"
, "NEXT_RUN_DATE"
, "LAST_START_DATE"
, "LAST_END_DATE"
, "RETRY_COUNT"
, "RUN_COUNT"
, "FAILURE_COUNT"
, "RUNNING_INSTANCE"
, "RUNNING_SLAVE"
, "DATABASE_ROLE"
, "INSTANCE_ID"
, "DIST_FLAGS"
, "OWNER_UDN"
, "CREDENTIAL_NAME"
, "CREDENTIAL_OWNER"
, "CREDENTIAL_OID"
, "FW_NAME"
, "FW_OID"
, "DEST_OID"
, "JOB_DEST_ID"
, "RUN_INVOKER"
, "CONNECT_CREDENTIAL_NAME"
, "CONNECT_CREDENTIAL_OWNER"
, "CONNECT_CREDENTIAL_OID"
, "PDB_ID"
, "CON_ID"
FROM CONTAINERS("SYS"."SCHEDULER$_JOB")