Chapter 2 -
Configuring Oracle Job Scheduling
||Oracle Tips by Burleson
start_date - The date when this window will take
effect. This may be in the future if the window is to be setup in
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
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:
-- Window with a predefined schedule.
window_name => 'test_window_1',
resource_plan => NULL,
schedule_name => 'TEST_HOURLY_SCHEDULE',
duration => INTERVAL '30' MINUTE,
window_priority => 'LOW',
comments => 'Window with a
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA