# su-oracle
Oracle> sqlplus "/as sysdba"
sql> exec dbms_scheduler.disable (' Monday_window ');
sql> exec dbms_scheduler.disable (' Tuesday_window ');
sql> exec dbms_scheduler.disable (' Wednesday_window ');
sql> exec dbms_scheduler.disable (' Thursday_window ');
sql> exec dbms_scheduler.disable (' Friday_window ');
sql> exec dbms_scheduler.disable (' Saturday_window ');
sql> exec dbms_scheduler.disable (' Sunday_window ');
sql> exec dbms_scheduler.disable (' Weekend_window ');
# su-oracle
Oracle> sqlplus "/as sysdba"
sql> exec dbms_scheduler.enable (' Monday_window ');
sql> exec dbms_scheduler.enable (' Tuesday_window ');
sql> exec dbms_scheduler.enable (' Wednesday_window ');
sql> exec dbms_scheduler.enable (' Thursday_window ');
sql> exec dbms_scheduler.enable (' Friday_window ');
sql> exec dbms_scheduler.enable (' Saturday_window ');
sql> exec dbms_scheduler.enable (' Sunday_window ');
Turn off Oracle timed tasks
1 Set The current resource manager plan to null (or another plan this is not restrictive):
Alter system set resource_manager_plan= ' Scope=both;
2 Change the active windows to use the Null Resource Manager plan (or other nonrestrictive plan) using:
Execute Dbms_scheduler.set_attribute (' Weeknight_window ', ' Resource_plan ', ');
Execute Dbms_scheduler.set_attribute (' Weekend_window ', ' Resource_plan ', ');
3 Then, for each window_name (Window_name from Dba_scheduler_windows), run:
Execute Dbms_scheduler.set_attribute (' <window name> ', ' Resource_plan ', ');
Sql> select * from Dba_scheduler_windows;
4 Open Resources Plan
Check The resource status (maybe need to set NULL or change the running time. Please contact with the Product engineers to confirm)
Sql> Select A.name, A.value from V$parameter a where a.name = ' Resource_manager_plan ';
Sql> Select Window_name, Resource_plan from Dba_scheduler_windows where resource_plan are NOT null;
If not NULL, please think the running time by the following:
Begin
Dbms_scheduler.set_attribute (name=> ' Monday_window ',attribute=> ' repeat_interval ',value=> ' freq=daily; byday=mon;byhour=3;byminute=0; Bysecond=0 ');
Dbms_scheduler.set_attribute (name=> ' Tuesday_window ',attribute=> ' repeat_interval ',value=> ' freq=daily; byday=tue;byhour=3;byminute=0; Bysecond=0 ');
Dbms_scheduler.set_attribute (name=> ' Wednesday_window ',attribute=> ' repeat_interval ',value=> ' freq=daily ; byday=wed;byhour=3;byminute=0; Bysecond=0 ');
Dbms_scheduler.set_attribute (name=> ' Thursday_window ',attribute=> ' repeat_interval ',value=> ' freq=daily; byday=thu;byhour=3;byminute=0; Bysecond=0 ');
Dbms_scheduler.set_attribute (name=> ' Friday_window ',attribute=> ' repeat_interval ',value=> ' freq=daily; byday=fri;byhour=3;byminute=0; Bysecond=0 ');
End
/
Begin
Dbms_scheduler.set_attribute (name=> ' Saturday_window ',attribute=> ' repeat_interval ',value=> ' freq=daily; byday=sat;byhour=3;byminute=0; Bysecond=0 ');
Dbms_scheduler.set_attribute (name=> ' Saturday_window ',attribute=> ' DURATION ',value=> ' +000 04:00:00 ');
Dbms_scheduler.set_attribute (name=> ' Sunday_window ',attribute=> ' repeat_interval ',value=> ' freq=daily; byday=sun;byhour=3;byminute=0; Bysecond=0 ');
Dbms_scheduler.set_attribute (name=> ' Sunday_window ',attribute=> ' DURATION ',value=> ' +000 04:00:00 ');
End
/
EXEC dbms_scheduler. Set_scheduler_attribute (' Default_timezone ', ' asia/tashkent ');
Oracle Scheduled Tasks