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
Scheduler Time Zone Before doing that, we have make sure the time zone region you want to set is valid for Oracle. Then we change… Read More »How to Set Scheduler Time Zone
PACKAGE DBMS_SCHEDULER I found that some subprograms of DBMS_SCHEDULER package are no listed in the Oracle documentation. However, we get the complete list by describing… Read More »DBMS_SCHEDULER Subprograms All Available List
Stopping a Running Job Sometimes, we may find scheduled jobs currently impact other running sessions, we may consider to turn it off right away. Killing… Read More »How DBMS_SCHEDULER.STOP_JOB