Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
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 |
START_DATE |
TIMESTAMP(6) WITH TIME ZONE |
Start date for the repeat interval | |
REPEAT_INTERVAL |
VARCHAR2(4000) |
Calendar syntax expression for the schedule | |
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 |