Re: Oracle RAC and jobs on one only Oracle only
From: Andreas Piesk <a.piesk_at_gmx.net>
Date: Mon, 25 Feb 2008 12:43:45 -0800 (PST)
Message-ID: <ee8edfc5-ef66-4875-a7e7-5157b4cf1495@d5g2000hsc.googlegroups.com>
> 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.
Date: Mon, 25 Feb 2008 12:43:45 -0800 (PST)
Message-ID: <ee8edfc5-ef66-4875-a7e7-5157b4cf1495@d5g2000hsc.googlegroups.com>
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.
regards,
-ap
Received on Mon Feb 25 2008 - 14:43:45 CST