Chapter 2 -
Configuring Oracle Job Scheduling
||Oracle Tips by Burleson
-- Window with an inline schedule.
window_name => 'test_window_2',
resource_plan => NULL,
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=hourly;
end_date => NULL,
duration => INTERVAL '30' MINUTE,
window_priority => 'LOW'
comments => 'Window with an inline
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
Information about windows can be displayed
using the dba_scheduler_windows view. The following script
uses this view:
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA