DBMS_SCHEDULER 11g chain affinity
Date: Wed, 7 Oct 2009 12:57:20 -0400
Oracle 11g 184.108.40.206 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?
ChrisReceived on Wed Oct 07 2009 - 11:57:20 CDT