Parameters in a Sequence
Posted: 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
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