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

VIEW: SYS.SCHEDULER$_CDB_JOB

Object Details
Object Name: SCHEDULER$_CDB_JOB
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

in all containers

[View Source]

Columns
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

CON_ID NUMBER

container id
Query Text

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
,      CON_ID
FROM SYS.SCHEDULER$_CDB_JOB;

Dependencies

[top of page]

SYS.SCHEDULER$_CDB_JOB does not reference any database object

SYS.SCHEDULER$_CDB_JOB is not referenced by any database object