Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


ALL_SCHEDULER_SCHEDULES displays information about the Scheduler schedules accessible to the current user.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the schedule
SCHEDULE_NAME VARCHAR2(30) NOT NULL Name of the schedule
SCHEDULE_TYPE VARCHAR2(8)   Type of the schedule:
  • ONCE - Repeat interval is NULL

  • CALENDAR - Oracle calendaring expression used as schedule

  • EVENT - Event schedule

START_DATE TIMESTAMP(6) WITH TIME ZONE   Start date for the repeat interval
REPEAT_INTERVAL VARCHAR2(4000)   Calendar syntax expression for the schedule
EVENT_QUEUE_OWNER VARCHAR2(30)   Owner of the source queue into which the event will be raised
EVENT_QUEUE_NAME VARCHAR2(30)   Name of the source queue into which the event will be raised
EVENT_QUEUE_AGENT VARCHAR2(30)   Name of the AQ agent used by the user on the event source queue (if it is a secure queue)
EVENT_CONDITION VARCHAR2(4000)   Boolean expression used as the subscription rule for the event on the source queue
END_DATE TIMESTAMP(6) WITH TIME ZONE   Cutoff date after which the schedule will not specify any dates
COMMENTS VARCHAR2(240)   Comments on the schedule