Parameters in a Sequence

sathyanveshi · Post by **sathyanveshi** » Wed Dec 08, 2004 10:29 am

Hi,

I have the following scenario. I have one sequence containing about 20 jobs. Each job loads one table from source to the target. I need to specify the connection parameters (Oracle username and password) in every job. I want to mention the parameters only once in the sequence and it needs to be inherited by the jobs in that sequence. Is that possible? If so, please let me know, how it can be achieved?

Cheers,
Mohan

kcbland · Post by **kcbland** » Wed Dec 08, 2004 10:52 am

No, you manually have to setup each job activity stage and put the Sequence parameters in as the derivation for all parameters.

kduke · Post by **kduke** » Wed Dec 08, 2004 12:24 pm

You might be able to fix one job and then copy it. After you copy it then change the job name. I think it will remember the parameter settings. Try it and let us know.