Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_SCHEDULER (10.2.0.2 linux x86_64 bit)
DBMS_SCHEDULER [message #286879] Mon, 10 December 2007 05:58 Go to next message
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 Go to previous message
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.
Previous Topic: First datetime in a block
Next Topic: Cursor ...
Goto Forum:
  


Current Time: Wed Feb 12 04:08:40 CST 2025