| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| 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 |
|
 Copyright © 2002, 2003, Oracle Corporation All Rights Reserved. |
|
