Home » Other » General » Prevent 10g r2 Schedules running in TEST environment
Prevent 10g r2 Schedules running in TEST environment [message #259390] Wed, 15 August 2007 08:15 Go to next message
yamon
Messages: 22
Registered: July 2006
Junior Member
Hi,

I have created a TEST database on a seperate server to 10g r2 LIVE, but the scheduler is running jobs in TEST. I have tried setting JOB_QUEUE_PROCESSES initialisation parameter to 0, but the schedules still run. I have disabled all the jobs after starting the TEST database, but I was wondering if there was a more effective method; maybe an initialization parameter or something?

Many thanks for any advice.

Yamon
Re: Prevent 10g r2 Schedules running in TEST environment [message #259409 is a reply to message #259390] Wed, 15 August 2007 09:43 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends it you use old jobs or new scheduler.
Old jobs are managed with JOB_QUEUE_PROCESSES, setting it to 0 disabled them.
New scheduler is managed by max_job_slave_processes or dbms_scheduler.set_scheduler_attribute.

Regards
Michel
Previous Topic: Test data management
Next Topic: DOUBT IN USER_TAB_COLUMNS
Goto Forum:
  


Current Time: Sat Dec 10 22:12:08 CST 2016

Total time taken to generate the page: 0.09832 seconds