Re: Oracle RAC and jobs on one only Oracle only

From: Andreas Piesk <>
Date: Mon, 25 Feb 2008 12:43:45 -0800 (PST)
Message-ID: <>

On 25 Feb., 21:19, 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

Original text of this message