Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-12
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
PDF · Mobi · ePub

ALL_SCHEDULER_RUNNING_CHAINS

ALL_SCHEDULER_RUNNING_CHAINS displays information about the chain steps of the running chains accessible to the current user (that is, those chains that the user has ALTER privileges for). In the 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) NOT NULL Owner of the job which is running the chain
JOB_NAME VARCHAR2(30) NOT NULL Name of the job which is running the chain
JOB_SUBNAME VARCHAR2(30)   Subname of the job which is running the chain (for a nested chain), else NULL
CHAIN_OWNER VARCHAR2(30) NOT NULL Owner of the chain being run
CHAIN_NAME VARCHAR2(30) NOT NULL Name of the chain being run
STEP_NAME VARCHAR2(30) NOT NULL Name of the step of the running chain
STATE VARCHAR2(15)   State of the running chain step:
  • NOT_STARTED

  • RUNNING

  • SUCCEEDED

  • STOPPED

  • FAILED

  • SCHEDULED

  • RETRY SCHEDULED

  • PAUSED

  • STALLED

ERROR_CODE NUMBER   Error code with which the step completed (if it has completed)
COMPLETED VARCHAR2(5)   Indicates whether the running chain step has completed (TRUE) or not (FALSE)
START_DATE TIMESTAMP(6) WITH TIME ZONE   Date when the running chain step started (if it has started)
END_DATE TIMESTAMP(6) WITH TIME ZONE   Date when the running chain step stopped (if it has stopped)
DURATION INTERVAL DAY(9) TO SECOND(6)   Amount of time it took the chain step to complete (if it has completed)
SKIP VARCHAR2(5)   Indicates whether the chain step should be skipped (TRUE) or not (FALSE)
PAUSE VARCHAR2(5)   Indicates whether the chain step should be paused after running (TRUE) or not (FALSE)
PAUSE_BEFOREFoot 1  VARCHAR2(5)   Indicates whether the chain step should be paused before running (TRUE) or not (FALSE)
RESTART_ON_RECOVERY VARCHAR2(5)   Indicates whether the chain step will be restarted on database recovery (TRUE) or not (FALSE)
RESTART_ON_FAILURE VARCHAR2(5)   Indicates whether the chain step will be restarted on application failure (TRUE) or not (FALSE)
STEP_JOB_SUBNAME VARCHAR2(30)   Subname of the job running the step
STEP_JOB_LOG_ID NUMBER   Log ID of the job running the step

Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).