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

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Mar 05 21:15:11 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.