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 theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the schedule |
|
|
|
Name of the schedule |
|
|
|
Type of the schedule:
|
|
|
|
Start date for the repeat interval |
|
|
|
Calendar syntax expression for the schedule |
|
|
|
Owner of the source queue into which the event will be raised |
|
|
|
Name of the source queue into which the event will be raised |
|
|
|
Name of the AQ agent used by the user on the event source queue (if it is a secure queue) |
|
|
|
Boolean expression used as the subscription rule for the event on the source queue |
|
|
|
Owner of the file watcher on which this schedule is based |
|
|
|
Name of the file watcher on which this schedule is based |
|
|
|
Cutoff date after which the schedule will not specify any dates |
|
|
|
Comments on the schedule |
See Also: