| |
 |
|
Oracle Tips by Burleson |
Chapter 2 -
Configuring Oracle Job Scheduling
Windows
-
start_date - The date when this window will take
effect. This may be in the future if the window is to be setup in
advance.
-
repeat_interval - The
definition of how often the window should open. A value of NULL
indicates that the window should only open once.
-
end_date - The date when
this window will stop. This combined with the start_date
parameter enables a window to be scheduled for a finite period of
time.
-
duration - The length of
time in minutes the window should remain open.
-
window_priority - The
priority (LOW or HIGH) of the window. In the event of multiple
windows opening at the same time, windows with a high priority take
precedence over windows with a low priority, which is the default.
-
comments - Free text
allowing the user to record additional information.
The following code shows how the
create_window procedures can be used:
BEGIN
-- Window with a predefined schedule.
DBMS_SCHEDULER.create_window (
window_name => 'test_window_1',
resource_plan => NULL,
schedule_name => 'TEST_HOURLY_SCHEDULE',
duration => INTERVAL '30' MINUTE,
window_priority => 'LOW',
comments => 'Window with a
predefined schedule.');
END;
/
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
