ALL_SCHEDULER_RUNNING_CHAINS

ALL_SCHEDULER_RUNNING_CHAINS shows the state of all chain steps of running chains visible to the current user (that is, those chains that the user has ALTER privileges for). In case of nested chains this view also enables you to traverse the hierarchy of the chain with a SQL statement that contains a CONNECT BY clause linking up the JOB_SUBNAME and STEP_JOB_SUBNAME columns.

Related Views

DBA_SCHEDULER_RUNNING_CHAINS shows the state of all chain steps of running chains in the database.
USER_SCHEDULER_RUNNING_CHAINS shows the state of all chain steps of running chains in the current user's schema. This view does not display the OWNER column.

Column	Datatype	Description
`OWNER`	`VARCHAR2(30)`	Job schema
`JOB_NAME`	`VARCHAR2(30)`	Job name
`JOB_SUBNAME`	`VARCHAR2(30)`	In the case of nested chains, subname of the parent job running this step (else NULL)
`CHAIN_OWNER`	`VARCHAR2(30)`	Chain schema
`CHAIN_NAME`	`VARCHAR2(30)`	Chain name
`STEP_NAME`	`VARCHAR2(30)`	Chain step name
`STATE`	`VARCHAR2(11)`	State of this running chain step. The state can be any of the following: NOT_STARTED, RUNNING, SUCCEEDED, STOPPED, FAILED, SCHEDULED, PAUSED, STALLED
`ERROR_CODE`	`NUMBER`	Error code with which this step completed (if it has completed)
`COMPLETED`	`VARCHAR2(5)`	Whether or not the running chain step has completed
`START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`	When the running chain step started (if it has started)
`END_DATE`	`TIMESTAMP(6) WITH TIME ZONE`	When the running chain step stopped (if it has stopped)
`DURATION`	`INTERVAL DAY(9) TO SECOND(6)`	How long it took this chain step to complete (if it has completed)
`SKIP`	`VARCHAR2(5)`	Whether or not this chain step should be skipped
`PAUSE`	`VARCHAR2(5)`	Whether or not this chain step should be paused after running
`RESTART_ON_RECOVERY`	`VARCHAR2(5)`	Whether or not this step will be restarted on database recovery
`STEP_JOB_SUBNAME`	`VARCHAR2(30)`	The subname of the job running this step
`STEP_JOB_LOG_ID`	`NUMBER`	The log ID of the job running this step