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

VIEW: SYS.CDB_SCHEDULER_SCHEDULES

Object Details
Object Name: CDB_SCHEDULER_SCHEDULES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All schedules in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Owner of the schedule
SCHEDULE_NAME VARCHAR2 (30) Yes Name of the schedule
SCHEDULE_TYPE VARCHAR2 (12)
Type of the schedule
START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
Start date for the repeat interval
REPEAT_INTERVAL VARCHAR2 (4000)
Calendar syntax expression for this schedule
EVENT_QUEUE_OWNER VARCHAR2 (128)
Owner of source queue into which event will be raised
EVENT_QUEUE_NAME VARCHAR2 (128)
Name of source queue into which event will be raised
EVENT_QUEUE_AGENT VARCHAR2 (128)
Name of AQ agent used by user on the event source queue (if it is a secure queue)
EVENT_CONDITION VARCHAR2 (4000)
Boolean expression used as subscription rule for event on the source queue
FILE_WATCHER_OWNER VARCHAR2 (261)
Owner of file watcher on which this schedule is based
FILE_WATCHER_NAME VARCHAR2 (261)
Name of file watcher on which this schedule is based
END_DATE TIMESTAMP(6) WITH TIME ZONE (13)
Cutoff date after which the schedule will not specify any dates
COMMENTS VARCHAR2 (240)
Comments on this schedule
CON_ID NUMBER

container id
Query Text

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


SELECT OWNER
,      SCHEDULE_NAME
,      SCHEDULE_TYPE
,      START_DATE
,      REPEAT_INTERVAL
,      EVENT_QUEUE_OWNER
,      EVENT_QUEUE_NAME
,      EVENT_QUEUE_AGENT
,      EVENT_CONDITION
,      FILE_WATCHER_OWNER
,      FILE_WATCHER_NAME
,      END_DATE
,      COMMENTS
,      CON_ID
FROM SYS.CDB_SCHEDULER_SCHEDULES;

Dependencies

[top of page]

SYS.CDB_SCHEDULER_SCHEDULES does not reference any database object

SYS.CDB_SCHEDULER_SCHEDULES is referenced by following:

SchemaPUBLIC
SynonymCDB_SCHEDULER_SCHEDULES