How to prevent scheduler jobs from running at instance startup I'm currently testing Oracle 11g restore procedures from RMAN backups. I can restore instances to another host, but problem I'm having is that as soon as I open the restored instance, scheduler jobs start immediately.

I can disable scheduler by running:

exec dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED','TRUE');


But I can't do this until after instance has started.

Is there a way to disable jobs before starting up the instance?
Set the job_queue_processes parameter to 0 before opening the database.