ALL_SCHEDULER_SCHEDULES displays information about the Scheduler schedules accessible to the current user.
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(30) |
NOT NULL |
Owner of the schedule |
SCHEDULE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the schedule |
SCHEDULE_TYPE |
VARCHAR2(8) |
Type of the 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(30) |
Owner of the source queue into which the event will be raised | |
EVENT_QUEUE_NAME |
VARCHAR2(30) |
Name of the source queue into which the event will be raised | |
EVENT_QUEUE_AGENT |
VARCHAR2(30) |
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 | |
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 |