Oracle PL/SQL for DBAs

Name

DBA_SCHEDULER_SCHEDULES

Synopsis

This view shows the named schedules defined in the database.

Column name	Description
OWNER	Owner of the schedule.
SCHEDULE_NAME	Name of the schedule.
START_DATE	Date and time when the schedule is supposed to start.
REPEAT_INTERVAL	Repeat interval (calendar string) that determines how often the schedule is repeated. Shown in the calendar string syntax (e.g., “FREQ=DAILY; BYMONTH=2”). See the section "Calendar Strings" in Chapter 8.
END_DATE	Date when the schedule ends.
COMMENTS	Comments on the schedule.

Oracle Database 10g Release 2 adds several new columns to the DBA_SCHEDULER_SCHEDULES view to support the event-based job triggering mechanism.

SCHEDULE_TYPE	Type of the schedule; may be ONCE, CALENDAR, or EVENT.
EVENT_QUEUE_OWNER	Name of the owner of the event queue.
EVENT_QUEUE_NAME	Name of the event queue.
EVENT_QUEUE_AGENT	Agent name of the event queue.
EVENT_CONDITION	Condition that will trigger the occurrence of the event.