[Home] [Help] [Dependency Information]
Object Name: | SCHEDULER$_CDB_LIGHTWEIGHT_JOB |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJ# | NUMBER | Yes | ||
PROGRAM_OID | NUMBER | |||
START_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
END_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
SCHEDULE_EXPR | VARCHAR2 | (4000) | ||
QUEUE_OWNER | VARCHAR2 | (128) | ||
QUEUE_NAME | VARCHAR2 | (128) | ||
QUEUE_AGENT | VARCHAR2 | (256) | ||
EVENT_RULE | VARCHAR2 | (261) | ||
SCHEDULE_ID | NUMBER | |||
LAST_ENABLED_TIME | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
CLASS_OID | NUMBER | |||
MXDUR_MSGID | RAW | (16) | ||
FLAGS | NUMBER | |||
CREATOR | VARCHAR2 | (128) | ||
CLIENT_ID | VARCHAR2 | (64) | ||
GUID | VARCHAR2 | (32) | ||
CHAR_ENV | VARCHAR2 | (4000) | ||
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 | |||
INSTANCE_ID | NUMBER | |||
FW_NAME | VARCHAR2 | (261) | ||
FW_OID | NUMBER | |||
DEST_OID | NUMBER | |||
DESTINATION | VARCHAR2 | (128) | ||
CREDENTIAL_NAME | VARCHAR2 | (128) | ||
CREDENTIAL_OWNER | VARCHAR2 | (128) | ||
CREDENTIAL_OID | NUMBER | |||
JOB_DEST_ID | NUMBER | |||
RUN_INVOKER | NUMBER | |||
CONNECT_CREDENTIAL_NAME | VARCHAR2 | (128) | ||
CONNECT_CREDENTIAL_OWNER | VARCHAR2 | (128) | ||
CONNECT_CREDENTIAL_OID | VARCHAR2 | (128) | ||
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, PROGRAM_OID
, START_DATE
, END_DATE
, SCHEDULE_EXPR
, QUEUE_OWNER
, QUEUE_NAME
, QUEUE_AGENT
, EVENT_RULE
, SCHEDULE_ID
, LAST_ENABLED_TIME
, CLASS_OID
, MXDUR_MSGID
, FLAGS
, CREATOR
, CLIENT_ID
, GUID
, CHAR_ENV
, JOB_STATUS
, NEXT_RUN_DATE
, LAST_START_DATE
, LAST_END_DATE
, RETRY_COUNT
, RUN_COUNT
, FAILURE_COUNT
, RUNNING_INSTANCE
, RUNNING_SLAVE
, INSTANCE_ID
, FW_NAME
, FW_OID
, DEST_OID
, DESTINATION
, CREDENTIAL_NAME
, CREDENTIAL_OWNER
, CREDENTIAL_OID
, JOB_DEST_ID
, RUN_INVOKER
, CONNECT_CREDENTIAL_NAME
, CONNECT_CREDENTIAL_OWNER
, CONNECT_CREDENTIAL_OID
, CON_ID
FROM SYS.SCHEDULER$_CDB_LIGHTWEIGHT_JOB;
SYS.SCHEDULER$_CDB_LIGHTWEIGHT_JOB does not reference any database object
SYS.SCHEDULER$_CDB_LIGHTWEIGHT_JOB is not referenced by any database object
|
|
|