DBA Data[Home] [Help]

VIEW: SYS.ALL_SCHEDULER_SCHEDULES

Source

View Text - Preformatted

SELECT "OWNER","SCHEDULE_NAME","SCHEDULE_TYPE","START_DATE","REPEAT_INTERVAL","EVENT_QUEUE_OWNER","EVENT_QUEUE_NAME","EVENT_QUEUE_AGENT","EVENT_CONDITION","FILE_WATCHER_OWNER","FILE_WATCHER_NAME","END_DATE","COMMENTS" FROM dba_scheduler_schedules
View Text - HTML Formatted

SELECT "OWNER"
, "SCHEDULE_NAME"
, "SCHEDULE_TYPE"
, "START_DATE"
, "REPEAT_INTERVAL"
, "EVENT_QUEUE_OWNER"
, "EVENT_QUEUE_NAME"
, "EVENT_QUEUE_AGENT"
, "EVENT_CONDITION"
, "FILE_WATCHER_OWNER"
, "FILE_WATCHER_NAME"
, "END_DATE"
, "COMMENTS"
FROM DBA_SCHEDULER_SCHEDULES