Re: Oracle RAC and jobs on one only Oracle only
Date: Mon, 25 Feb 2008 12:43:45 -0800 (PST)
On 25 Feb., 21:19, jharbo..._at_googlemail.com wrote:
> My other query is for some Oracle jobs that send out email every week.
> How can you only the Oracle jobs on one Oracle to run so you only get
> one email. If the email job runs on both Oracles we would get two
> emails. The consultant did not know the answer.
you could set the job attribute instance_stickiness to false to run the job on the first available instance or you create a special service and bind the job class on this service.
-ap Received on Mon Feb 25 2008 - 14:43:45 CST