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

VIEW: SYS.USER_SCHEDULER_SCHEDULES

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

Schedules belonging to the current user

[View Source]

Columns
Name Datatype Length Mandatory Comments
SCHEDULE_NAME VARCHAR2 (128) 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
Query Text

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


SELECT 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
FROM SYS.USER_SCHEDULER_SCHEDULES;

Dependencies

[top of page]

SYS.USER_SCHEDULER_SCHEDULES references the following:

SchemaSYS
TableOBJ$
TableSCHEDULER$_SCHEDULE
SYS.USER_SCHEDULER_SCHEDULES is referenced by following:

SchemaPUBLIC
SynonymUSER_SCHEDULER_SCHEDULES