“Holy Maintenance Jobs, DBAtman!!”
First some considerations: We could just disable window changing, once the jobs are related to windows, and Resource Manager Plans use to be as well. Keep that in mind. However, to answer the question directly:
# To disable/enable all maintenance jobs in from/for all windows:
EXEC DBMS_AUTO_TASK_ADMIN.disable; EXEC DBMS_AUTO_TASK_ADMIN.enable;
# And to disable/enable specific maintenance jobs from/for all windows:
exec DBMS_AUTO_TASK_ADMIN.DISABLE('AUTO OPTIMIZER STATS COLLECTION',NULL, NULL);
exec DBMS_AUTO_TASK_ADMIN.DISABLE('AUTO SPACE ADVISOR',NULL, NULL);
exec DBMS_AUTO_TASK_ADMIN.DISABLE('SQL TUNING ADVISOR', NULL, NULL);
exec DBMS_AUTO_TASK_ADMIN.ENABLE('AUTO OPTIMIZER STATS COLLECTION',NULL, NULL);
exec DBMS_AUTO_TASK_ADMIN.ENABLE('AUTO SPACE ADVISOR',NULL, NULL);
exec DBMS_AUTO_TASK_ADMIN.ENABLE('SQL TUNING ADVISOR', NULL, NULL);
More information and details about it can be taken from here: https://docs.oracle.com/cd/E11882_01/server.112/e25494/tasks.htm#ADMIN11836
Na, na, na, na, na, na, na, na, na, na, na, na… DBAtman!
dbatman.blog 