 |
|
Oracle Tips by Burleson |
Chapter 2 -
Configuring Oracle Job Scheduling
Windows
PROCEDURE close_window (
window_name IN VARCHAR2)
The parameters associated with these procedures
and their usage are as follows:
-
window_name - A name that
uniquely identifies the window.
-
duration - The length of
time, in minutes, the window should remain open.
-
force - When set to FALSE,
attempting to open a window when one is already open will result in
an error unless the currently open window is the one that is
attempting to open. In this case, the close time is set to the
current system time plus the specified duration.
Closing a window causes all jobs associated
with that window to be stopped.
The following example opens then closes
test_window_2. Notice how the active window switches back to
weekend_window when test_window_2 is closed.
BEGIN
-- Open window.
DBMS_SCHEDULER.open_window (
window_name => 'test_window_2',
duration => INTERVAL '1' MINUTE,
force => TRUE);
END;
/
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|