Scheduler management

Managing the Scheduler in the database is a little vague. Most things are defined very clearly, but there is no such thing as the ability to stop or start the Scheduler in a supported way. In the Oracle RDBMS, there is the system privilege MANAGE SCHEDULER that enables you to define job classes, windows, and window groups. Setting and reading Scheduler attributes is controlled by this privilege, as is purging the Scheduler logs. The Scheduler attributes are listed in the ALL_SCHEDULER_GLOBAL_ATTRIBUTE view. Not all attributes listed here can be modified, and not all Scheduler attributes are listed. The current_open_window, for example, is a read-only and changes when the next window opens or the current window closes.

max_job_slave_processes can be used to limit the number of processes the Scheduler is allowed to use. The max_job_slave_processes parameter cannot be set to 0. In the earlier versions of Oracle, we could prevent the dbms_jobs jobs from running by setting...