3.63 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

See Also:

• "DBA_SCHEDULER_SCHEDULES"

• "USER_SCHEDULER_SCHEDULES"