[Home] [Help] [Dependency Information]
Object Name: | SCHEDULER$_JOB |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SCHEDULER$_JOB_PK | NORMAL | UNIQUE | SYSTEM | OBJ# |
I_SCHEDULER_JOB1 | FUNCTION-BASED NORMAL | NONUNIQUE | SYSTEM | SYS_EXTRACT_UTC("NEXT_RUN_DATE") |
I_SCHEDULER_JOB2 | NORMAL | NONUNIQUE | SYSTEM | CLASS_OID |
I_SCHEDULER_JOB3 | NORMAL | NONUNIQUE | SYSTEM | SCHEDULE_ID |
I_SCHEDULER_JOB4 | FUNCTION-BASED NORMAL | NONUNIQUE | SYSTEM | BITAND("JOB_STATUS",515) |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJ# | NUMBER | Yes | ||
PROGRAM_OID | NUMBER | |||
PROGRAM_ACTION | VARCHAR2 | (4000) | ||
SCHEDULE_EXPR | VARCHAR2 | (4000) | ||
QUEUE_OWNER | VARCHAR2 | (128) | ||
QUEUE_NAME | VARCHAR2 | (128) | ||
QUEUE_AGENT | VARCHAR2 | (256) | ||
EVENT_RULE | VARCHAR2 | (261) | ||
SCHEDULE_LIMIT | INTERVAL DAY(3) TO SECOND(0) | (11) | ||
SCHEDULE_ID | NUMBER | |||
START_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
END_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
LAST_ENABLED_TIME | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
CLASS_OID | NUMBER | |||
PRIORITY | NUMBER | |||
JOB_WEIGHT | NUMBER | |||
NUMBER_OF_ARGS | NUMBER | |||
MAX_RUNS | NUMBER | |||
MAX_FAILURES | NUMBER | |||
MAX_RUN_DURATION | INTERVAL DAY(3) TO SECOND(0) | (11) | ||
MXDUR_MSGID | RAW | (16) | ||
FLAGS | NUMBER | |||
COMMENTS | VARCHAR2 | (240) | ||
USER_CALLBACK | VARCHAR2 | (386) | ||
USER_CALLBACK_CTX | NUMBER | |||
CREATOR | VARCHAR2 | (128) | ||
CLIENT_ID | VARCHAR2 | (64) | ||
GUID | VARCHAR2 | (32) | ||
NLS_ENV | VARCHAR2 | (4000) | ||
ENV | RAW | (32) | ||
CHAR_ENV | VARCHAR2 | (4000) | ||
SOURCE | VARCHAR2 | (128) | ||
DESTINATION | VARCHAR2 | (128) | ||
JOB_STATUS | NUMBER | |||
NEXT_RUN_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
LAST_START_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
LAST_END_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
RETRY_COUNT | NUMBER | |||
RUN_COUNT | NUMBER | |||
FAILURE_COUNT | NUMBER | |||
RUNNING_INSTANCE | NUMBER | |||
RUNNING_SLAVE | NUMBER | |||
DATABASE_ROLE | VARCHAR2 | (16) | ||
INSTANCE_ID | NUMBER | |||
DIST_FLAGS | NUMBER | |||
OWNER_UDN | VARCHAR2 | (4000) | ||
CREDENTIAL_NAME | VARCHAR2 | (128) | ||
CREDENTIAL_OWNER | VARCHAR2 | (128) | ||
CREDENTIAL_OID | NUMBER | |||
FW_NAME | VARCHAR2 | (261) | ||
FW_OID | NUMBER | |||
DEST_OID | NUMBER | |||
JOB_DEST_ID | NUMBER | |||
RUN_INVOKER | NUMBER | |||
CONNECT_CREDENTIAL_NAME | VARCHAR2 | (128) | ||
CONNECT_CREDENTIAL_OWNER | VARCHAR2 | (128) | ||
CONNECT_CREDENTIAL_OID | NUMBER | |||
PDB_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, PROGRAM_OID
, PROGRAM_ACTION
, SCHEDULE_EXPR
, QUEUE_OWNER
, QUEUE_NAME
, QUEUE_AGENT
, EVENT_RULE
, SCHEDULE_LIMIT
, SCHEDULE_ID
, START_DATE
, END_DATE
, LAST_ENABLED_TIME
, CLASS_OID
, PRIORITY
, JOB_WEIGHT
, NUMBER_OF_ARGS
, MAX_RUNS
, MAX_FAILURES
, MAX_RUN_DURATION
, MXDUR_MSGID
, FLAGS
, COMMENTS
, USER_CALLBACK
, USER_CALLBACK_CTX
, CREATOR
, CLIENT_ID
, GUID
, NLS_ENV
, ENV
, CHAR_ENV
, SOURCE
, DESTINATION
, JOB_STATUS
, NEXT_RUN_DATE
, LAST_START_DATE
, LAST_END_DATE
, RETRY_COUNT
, RUN_COUNT
, FAILURE_COUNT
, RUNNING_INSTANCE
, RUNNING_SLAVE
, DATABASE_ROLE
, INSTANCE_ID
, DIST_FLAGS
, OWNER_UDN
, CREDENTIAL_NAME
, CREDENTIAL_OWNER
, CREDENTIAL_OID
, FW_NAME
, FW_OID
, DEST_OID
, JOB_DEST_ID
, RUN_INVOKER
, CONNECT_CREDENTIAL_NAME
, CONNECT_CREDENTIAL_OWNER
, CONNECT_CREDENTIAL_OID
, PDB_ID
FROM SYS.SCHEDULER$_JOB;
SYS.SCHEDULER$_JOB does not reference any database object
SYS.SCHEDULER$_JOB is referenced by following:
|
|
|