[Home] [Help] [Dependency Information]

TABLE: SYS.SCHEDULER$_LWJOB_OBJ

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: SCHEDULER$_LOBJ_PK

1. OBJ#

Unique Key: SCHEDULER$_LOBJ_UK

1. USERID
2. NAME
3. SUBNAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
SCHEDULER$_LOBJ_PK	NORMAL	UNIQUE	SYSTEM	OBJ#
SCHEDULER$_LOBJ_UK	NORMAL	UNIQUE	SYSTEM	USERID NAME SUBNAME

Columns

Query Text

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

SELECT OBJ#
,      USERID
,      NAME
,      SUBNAME
,      PRGOID
,      CREATION_TIME
,      MOD_TIME
,      SPEC_TIME
,      FLAGS
FROM SYS.SCHEDULER$_LWJOB_OBJ;

Dependencies

[top of page]

SYS.SCHEDULER$_LWJOB_OBJ does not reference any database object

SYS.SCHEDULER$_LWJOB_OBJ is referenced by following:

SYS

ALL_SCHEDULER_JOBS

ALL_SCHEDULER_JOB_ARGS

ALL_SCHEDULER_JOB_DESTS

ALL_SCHEDULER_RUNNING_JOBS

DBA_SCHEDULER_JOBS

DBA_SCHEDULER_JOB_ARGS

DBA_SCHEDULER_JOB_DESTS

DBA_SCHEDULER_RUNNING_JOBS

DBMS_ISCHED - show dependent code

DBMS_SCHED_MAIN_EXPORT - show dependent code

USER_SCHEDULER_JOBS

USER_SCHEDULER_JOB_ARGS

USER_SCHEDULER_JOB_DESTS

USER_SCHEDULER_RUNNING_JOBS