Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03 |
|
|
View PDF |
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(30) |
NOT NULL |
Owner of the schedule |
SCHEDULE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the schedule |
SCHEDULE_TYPE |
VARCHAR2(8) |
The type of schedule. Possible values are as follows:
|
|
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 |