 |
|
Oracle Tips by Burleson |
Chapter 2 -
Configuring Oracle Job Scheduling
Windows
Windows can be removed using the drop_window procedure.
PROCEDURE drop_window (
window_name IN VARCHAR2,
force IN BOOLEAN DEFAULT
FALSE)
The parameters associated with this procedure
and their usage are as follows:
-
window_name - A single or
comma separated list of window names. If a window group name is
specified, all windows within that group will be dropped. In
addition, all jobs that use the specified window or window group as
a schedule will be disabled, although running jobs will complete
normally.
-
force - When set to FALSE,
attempting to drop an open window will result in an error. When set
to TRUE the open window is closed before it is dropped.
The following example drops the two test
windows that were created earlier:
BEGIN
DBMS_SCHEDULER.drop_window (
window_name =>
'test_window_1,test_window_2',
force => TRUE);
END;
/
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
