Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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

Column Datatype NULL 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