DBMS_SCHEDULER [message #286879] |
Mon, 10 December 2007 05:58  |
colesg
Messages: 11 Registered: October 2007 Location: London
|
Junior Member |

|
|
Hi
I have a dbms_scheduler chain which runs SP in a certain order and checks to see if they have complete successfully before continuing. I have programs associated with each step. What I want to do is have different jobs that run the same chain but passes a different argument through per job.
eaxmple
sched 1 => job 1 => generic chain
sched 2 => job 2 => generic chain
After looking at the oracle documentation it looks like you cannot pass arguments to jobs that are associated with chains.
Does anyone know a way round this please. It is a simple concept so not sure why it is not possible.
Any help or points in the right direction will be much appreciated.
cheers
Gary
|
|
|
Re: DBMS_SCHEDULER [message #286964 is a reply to message #286879] |
Mon, 10 December 2007 13:27  |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
I haven't tried it, but as you say the concept is simple. If you can determine a unique chain id for that run, you should be able to save your parameter args to your own control table and have jobs in that chain read them from your table.
|
|
|