DBMS_SCHEDULER 11g chain affinity

From: Christopher Boyle <cboyle_at_onboardinformatics.com>
Date: Wed, 7 Oct 2009 12:57:20 -0400
Message-ID: <006501ca476f$3d8d41d0$b8a7c570$_at_com>

Good Morning

Oracle 11g RAC on 2 Windows boxes.  

I have managed thru the use of PSexec to be able to call external procedures using dbms_scheduler. I have set up a chain with a list of programs but the ones executed on instance 1 fail while the ones executed on instance 2 succeed. I have looked at the documentation and not found a way to restrict the actual programs to a particular node, only job that calls the chain has an affinity attribute. Can anyone suggest a method to accomplish this while I determine why instance 1 hates me?  



Received on Wed Oct 07 2009 - 11:57:20 CDT

Original text of this message