4.64 ALL_SCHEDULER_SCHEDULES

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

Related Views

  • DBA_SCHEDULER_SCHEDULES displays information about all Scheduler schedules in the database.

  • USER_SCHEDULER_SCHEDULES displays information about the Scheduler schedules owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the schedule

SCHEDULE_NAME

VARCHAR2(128)

NOT NULL

Name of the schedule

SCHEDULE_TYPE

VARCHAR2(12)

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(128)

Owner of the source queue into which the event will be raised

EVENT_QUEUE_NAME

VARCHAR2(128)

Name of the source queue into which the event will be raised

EVENT_QUEUE_AGENT

VARCHAR2(523)

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

FILE_WATCHER_OWNER

VARCHAR2(261)

Owner of the file watcher on which this schedule is based

FILE_WATCHER_NAME

VARCHAR2(261)

Name of the file watcher on which this schedule is based

END_DATE

TIMESTAMP(6) WITH TIME ZONE

Cutoff date after which the schedule will not specify any dates

COMMENTS

VARCHAR2(4000)

Comments on the schedule