Oracle PL/SQL for DBAs

Disabling and Enabling Windows

Instead of dropping a window, you may want to disable it so that it will never open automatically. To disable a window, use the procedure DISABLE, as shown here.

    BEGIN
       DBMS_SCHEDULER.disable (NAME => 'window1');
    END;

If the window named window1 is currently open, this operation will fail. To forcibly disable a window, you must use the FORCE parameter as follows:

    BEGIN
       DBMS_SCHEDULER.disable (NAME => 'window1', FORCE=>TRUE);
    END;

This will not close the currently open window, but it will force the window not to open in the future.

Similarly, to enable a disabled window, use the ENABLE procedure :

    BEGIN
       DBMS_SCHEDULER.enable (NAME => 'window1');
    END;

Note that the ENABLE and DISABLE procedures shown here are the same ENABLE/DISABLE procedures used for other Scheduler objects, such as jobs, schedules, and programs.