++ To disable status column to FALSE from DBA_SCHEDULER_WINDOWS
exec DBMS_SCHEDULER.DISABLE ( '"MONDAY_WINDOW"');
exec DBMS_SCHEDULER.DISABLE ( '"TUESDAY_WINDOW"');
exec DBMS_SCHEDULER.DISABLE ( '"WEDNESDAY_WINDOW"');
exec DBMS_SCHEDULER.DISABLE ( '"THURSDAY_WINDOW"');
exec DBMS_SCHEDULER.DISABLE ( '"FRIDAY_WINDOW"');
exec DBMS_SCHEDULER.DISABLE ( '"SATURDAY_WINDOW"');
exec DBMS_SCHEDULER.DISABLE ( '"SUNDAY_WINDOW"');
++ To disable active column to FALSE from DBA_SCHEDULER_WINDOWS
exec DBMS_SCHEDULER.CLOSE_WINDOW ('"MONDAY_WINDOW"');
exec DBMS_SCHEDULER.CLOSE_WINDOW ('"TUESDAY_WINDOW"');
exec DBMS_SCHEDULER.CLOSE_WINDOW ('"WEDNESDAY_WINDOW"');
exec DBMS_SCHEDULER.CLOSE_WINDOW ('"THURSDAY_WINDOW"');
exec DBMS_SCHEDULER.CLOSE_WINDOW ('"FRIDAY_WINDOW"');
exec DBMS_SCHEDULER.CLOSE_WINDOW ('"SATURDAY_WINDOW"');
exec DBMS_SCHEDULER.CLOSE_WINDOW ('"SUNDAY_WINDOW"');
SQL> select WINDOW_NAME,ENABLED,ACTIVE,RESOURCE_PLAN,NEXT_START_DATE, DURATION from DBA_SCHEDULER_WINDOWS;
WINDOW_NAME ENABL ACTIV RESOURCE_PLAN NEXT_START_DATE DURATION
-------------------- ----- ----- ------------------------------ --------------------------------------------- ---------------
MONDAY_WINDOW FALSE FALSE 20-JUL-15 01.00.00 AM AFRICA/JOHANNESBURG +000 06:00:00
TUESDAY_WINDOW FALSE FALSE 21-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG +000 03:00:00
WEDNESDAY_WINDOW FALSE FALSE 22-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG +000 03:00:00
THURSDAY_WINDOW FALSE FALSE 23-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG +000 03:00:00
FRIDAY_WINDOW FALSE FALSE 24-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG +000 03:00:00
SATURDAY_WINDOW FALSE FALSE 18-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG +000 03:00:00
SUNDAY_WINDOW FALSE FALSE 19-JUL-15 02.00.00 AM AFRICA/JOHANNESBURG
exec DBMS_SCHEDULER.DISABLE ( '"MONDAY_WINDOW"');
exec DBMS_SCHEDULER.DISABLE ( '"TUESDAY_WINDOW"');
exec DBMS_SCHEDULER.DISABLE ( '"WEDNESDAY_WINDOW"');
exec DBMS_SCHEDULER.DISABLE ( '"THURSDAY_WINDOW"');
exec DBMS_SCHEDULER.DISABLE ( '"FRIDAY_WINDOW"');
exec DBMS_SCHEDULER.DISABLE ( '"SATURDAY_WINDOW"');
exec DBMS_SCHEDULER.DISABLE ( '"SUNDAY_WINDOW"');
++ To disable active column to FALSE from DBA_SCHEDULER_WINDOWS
exec DBMS_SCHEDULER.CLOSE_WINDOW ('"MONDAY_WINDOW"');
exec DBMS_SCHEDULER.CLOSE_WINDOW ('"TUESDAY_WINDOW"');
exec DBMS_SCHEDULER.CLOSE_WINDOW ('"WEDNESDAY_WINDOW"');
exec DBMS_SCHEDULER.CLOSE_WINDOW ('"THURSDAY_WINDOW"');
exec DBMS_SCHEDULER.CLOSE_WINDOW ('"FRIDAY_WINDOW"');
exec DBMS_SCHEDULER.CLOSE_WINDOW ('"SATURDAY_WINDOW"');
exec DBMS_SCHEDULER.CLOSE_WINDOW ('"SUNDAY_WINDOW"');
SQL> select WINDOW_NAME,ENABLED,ACTIVE,RESOURCE_PLAN,NEXT_START_DATE, DURATION from DBA_SCHEDULER_WINDOWS;
WINDOW_NAME ENABL ACTIV RESOURCE_PLAN NEXT_START_DATE DURATION
-------------------- ----- ----- ------------------------------ --------------------------------------------- ---------------
MONDAY_WINDOW FALSE FALSE 20-JUL-15 01.00.00 AM AFRICA/JOHANNESBURG +000 06:00:00
TUESDAY_WINDOW FALSE FALSE 21-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG +000 03:00:00
WEDNESDAY_WINDOW FALSE FALSE 22-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG +000 03:00:00
THURSDAY_WINDOW FALSE FALSE 23-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG +000 03:00:00
FRIDAY_WINDOW FALSE FALSE 24-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG +000 03:00:00
SATURDAY_WINDOW FALSE FALSE 18-JUL-15 04.00.00 AM AFRICA/JOHANNESBURG +000 03:00:00
SUNDAY_WINDOW FALSE FALSE 19-JUL-15 02.00.00 AM AFRICA/JOHANNESBURG
No comments:
Post a Comment