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

TABLE: SYS.SCHEDULER$_REMOTE_JOB_STATE

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: SCHEDULER$_RJS_PK
  1. ColumnJOBOID
  2. ColumnDESTINATION
Indexes
Index Type Uniqueness Tablespace Column
SCHEDULER$_RJS_PK NORMAL UNIQUE TablespaceSYSTEM ColumnJOBOID
ColumnDESTINATION
Columns
Name Datatype Length Mandatory Comments
JOBOID NUMBER
Yes
DESTINATION VARCHAR2 (512) Yes
NEXT_START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
RUN_COUNT NUMBER

FAILURE_COUNT NUMBER

RETRY_COUNT NUMBER

LAST_START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
LAST_END_DATE TIMESTAMP(6) WITH TIME ZONE (13)
JOB_STATUS NUMBER

Query Text

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


SELECT JOBOID
,      DESTINATION
,      NEXT_START_DATE
,      RUN_COUNT
,      FAILURE_COUNT
,      RETRY_COUNT
,      LAST_START_DATE
,      LAST_END_DATE
,      JOB_STATUS
FROM SYS.SCHEDULER$_REMOTE_JOB_STATE;

Dependencies

[top of page]

SYS.SCHEDULER$_REMOTE_JOB_STATE does not reference any database object

SYS.SCHEDULER$_REMOTE_JOB_STATE is referenced by following:

SchemaSYS
ViewALL_SCHEDULER_REMOTE_JOBSTATE
ViewDBA_SCHEDULER_REMOTE_JOBSTATE
ViewUSER_SCHEDULER_REMOTE_JOBSTATE