DBA Data[Home] [Help] [Dependency Information]

TABLE: SYS.SCHEDULER$_STEP_STATE

Object Details
Object Name: SCHEDULER$_STEP_STATE
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: SCHEDULER$_STEP_STATE_PK
  1. ColumnJOB_OID
  2. ColumnSTEP_NAME
Indexes
Index Type Uniqueness Tablespace Column
SCHEDULER$_STEP_STATE_PK NORMAL UNIQUE TablespaceSYSAUX ColumnJOB_OID
ColumnSTEP_NAME
Columns
Name Datatype Length Mandatory Comments
JOB_OID NUMBER
Yes
STEP_NAME VARCHAR2 (128) Yes
STATUS CHAR (1)
ERROR_CODE NUMBER

START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
END_DATE TIMESTAMP(6) WITH TIME ZONE (13)
JOB_STEP_OID NUMBER

JOB_STEP_LOG_ID NUMBER

DESTINATION VARCHAR2 (128)
FLAGS NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT JOB_OID
,      STEP_NAME
,      STATUS
,      ERROR_CODE
,      START_DATE
,      END_DATE
,      JOB_STEP_OID
,      JOB_STEP_LOG_ID
,      DESTINATION
,      FLAGS
FROM SYS.SCHEDULER$_STEP_STATE;

Dependencies

[top of page]

SYS.SCHEDULER$_STEP_STATE does not reference any database object

SYS.SCHEDULER$_STEP_STATE is referenced by following:

SchemaSYS
ViewALL_SCHEDULER_RUNNING_CHAINS
ViewDBA_SCHEDULER_RUNNING_CHAINS
Package BodyDBMS_ISCHED - show dependent code
ViewUSER_SCHEDULER_RUNNING_CHAINS