setting job argument value for a specific progarm in a chain job
Hello,
I'm trying to find a way to set argument value for a specific program or for each program in a chain job.
for instance; I have a chain job with 3 programs in it
PROGRAM1 (Argument1, Argument2, Argument3)
PROGRAM2 (ArgumentA, Argument2, Argument3)
PROGRAM3 (ArgumentB, Argument1, Argument2)
I want to set these arguments' value in a chain job, now SET_JOB_ARGUMENT_VALUE can set the value of the argument by job but It's not clear how it will address the argument in a chain job having several programs.
can it be done by using positional reference, like let's say chain job is 'mychainjob', for setting PROGRAM3's ArgumentB and Argument2 which are the 7th and 9th arguments in the chain, is it possible to use:
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE ('mychainjob', 7, 'value_for_prog3_argB');
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE ('mychainjob', 9, 'value_for_prog3_arg2');
if not, anyone has any ideas?
Regards,
Tony