Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

job_queue_processes set to 0

646595Dec 2 2008 — edited Dec 2 2008

Hi guys,

one question.

Next Weekend i have to migrate the database cluster from the old server onto new server but there is one Problem. How can i prevent that all database jobs are running after starting the database?

I read about the parameter job_queue_processes, you can set them to 0 and it prevents the run of each database job.

Is this right, and if yes is this true for dba_jobs and dba_scheduler_jobs?

best regards

sascha

This post has been answered by 181444 on Dec 2 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 30 2008

Added on Dec 2 2008

#general-database-discussions

5 comments

1,173 views