Oracle Job Scheduling Robust Task Management dbms_job Oracle10g dbms_scheduler Windows create_window dba_scheduler

Phone
800-766-1884

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 2 - Configuring Oracle Job Scheduling

Windows

BEGIN
-- Window with an inline schedule.
DBMS_SCHEDULER.create_window (
    window_name     => 'test_window_2',
    resource_plan   => NULL,
    start_date      => SYSTIMESTAMP,
    repeat_interval => 'freq=hourly; byminute=0',
    end_date        => NULL,
    duration        => INTERVAL '30' MINUTE,
    window_priority => 'LOW'
    comments        => 'Window with an inline schedule.');
END;

The SYS user is the owner of all windows, so any schedules referenced by them must also be owned by SYS.

Figure 2.13 shows the Create Window screen in the OEM 10g DB Control.

Figure 2.13 – OEM 10g DB Control: Create Window

Information about windows can be displayed using the dba_scheduler_windows view. The following script uses this view:

The above text is an excerpt from:

Oracle Job Scheduling
Creating Robust Task Management with dbms_job and Oracle10g dbms_scheduler

ISBN 0-9744486-6-4

by Dr. Timothy S. Hall

http://www.rampant-books.com/book_2005_1_scheduling.htm

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA