ALL_SCHEDULER_SCHEDULES

Previous Next JavaScript must be enabled to correctly display this content

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(128)`		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(240)`		Comments on the schedule

See Also: