[Home] [Help] [Dependency Information]
Object Name: | CDB_SCHEDULER_RUNNING_CHAINS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All steps of all running chains in the database in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | Yes | Owner of the job which is running the chain |
JOB_NAME | VARCHAR2 | (30) | Yes | Name of the job which is running the chain |
JOB_SUBNAME | VARCHAR2 | (30) | Subname of the job which is running the chain (for a subchain) | |
CHAIN_OWNER | VARCHAR2 | (30) | Yes | Owner of the chain being run |
CHAIN_NAME | VARCHAR2 | (30) | Yes | Name of the chain being run |
STEP_NAME | VARCHAR2 | (128) | Yes | Name of this step of the running chain |
STATE | VARCHAR2 | (15) | State of this step | |
ERROR_CODE | NUMBER | Error code of this step, if it has finished running | ||
COMPLETED | VARCHAR2 | (5) | Whether this step has completed | |
START_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | When this step started, if it has already started | |
END_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | When this job step finished running, if it has finished running | |
DURATION | INTERVAL DAY(9) TO SECOND(6) | (11) | How long this step took to complete, if it has completed | |
SKIP | VARCHAR2 | (5) | Whether this step will be skipped or not | |
PAUSE | VARCHAR2 | (5) | Whether this step will be paused after running or not | |
PAUSE_BEFORE | VARCHAR2 | (5) | Whether this step will be paused before running or not | |
RESTART_ON_RECOVERY | VARCHAR2 | (5) | Whether this step will be restarted on database recovery | |
RESTART_ON_FAILURE | VARCHAR2 | (5) | Whether this step should be retried on application failure | |
STEP_JOB_SUBNAME | VARCHAR2 | (30) | Subname of the job running this step, if the step job has been created | |
STEP_JOB_LOG_ID | NUMBER | Log id of the step job if it has completed and has been logged. | ||
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, JOB_NAME
, JOB_SUBNAME
, CHAIN_OWNER
, CHAIN_NAME
, STEP_NAME
, STATE
, ERROR_CODE
, COMPLETED
, START_DATE
, END_DATE
, DURATION
, SKIP
, PAUSE
, PAUSE_BEFORE
, RESTART_ON_RECOVERY
, RESTART_ON_FAILURE
, STEP_JOB_SUBNAME
, STEP_JOB_LOG_ID
, CON_ID
FROM SYS.CDB_SCHEDULER_RUNNING_CHAINS;
SYS.CDB_SCHEDULER_RUNNING_CHAINS does not reference any database object
SYS.CDB_SCHEDULER_RUNNING_CHAINS is referenced by following:
|
|
|