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!

Disableing DBMS_SCHEDULER queues when cloning

brbarberJan 6 2009 — edited Jan 6 2009

I am creating a clone of my production database using RMAN and don't want the jobs in the DBMS_SCHEDULER to start once the clone is done. This was easy to do with DBA_JOBS by just setting JOB_QUEUE_PROCESSES=0, but I can't seam find a way to keep the jobs in DBMS_SCHEDULER from starting. I have tried using DBMS_SCHEDULER.DISABLE immediately upon completing the clone, but jobs have already started running.

Any ideas??
--Bruce

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 3 2009

Added on Jan 6 2009

#general-database-discussions

6 comments

970 views