Friday, 17 July 2015

How to make status column to False in DBA_SCHEDULER_WINDOWS

++ 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                    

No comments: