How to Enable AutoTask
DBMS_AUTO_TASK_ADMIN.ENABLE To enable AUTOTASK back to work, we just revert the process of disabling AUTOTASK jobs. Let's see the steps. Check AutoTask Here we query… Read More »How to Enable AutoTask
ORA$AUTOTASK
How to Disable AutoTask
DBMS_AUTO_TASK_ADMIN.DISABLE In the previous post, we've talked about how to modify the starting time and duration of maintenance windows to make the scheduled AUTOTASK work… Read More »How to Disable AutoTask
How DBMS_SCHEDULER.SET_ATTRIBUTE
DBMS_SCHEDULER.SET_ATTRIBUTE The default maintenance window for weekdays is from 22:00 to the next day 02:00, which may be still too early for some batch jobs,… Read More »How DBMS_SCHEDULER.SET_ATTRIBUTE