adding job parameter to many jobs

Luk · Post by **Luk** » Thu Apr 28, 2005 4:32 am

Hi all!

Is it possible to add 1 (the same) job parameter to many jobs (i.e 50 or more) in one time??
Or must I add it manualy many times (opening each job and add parameter)??

Regards

kduke · Post by **kduke** » Thu Apr 28, 2005 4:53 am

There are several routines posted that will do this. I posted one, Ray and Ken also posted routines. A more complete solution is to buy Parameter Manager from www.tools4datastage.com.

dsquestion · Post by **dsquestion** » Thu Apr 28, 2005 5:05 am

Hi luk,
Instead of going parameters for 50 jobs why cant you use environmental variables which is a good solution for your requirement.

Luk · Post by **Luk** » Thu Apr 28, 2005 5:30 am

thanks I will search routines

Instead of going parameters for 50 jobs why cant you use environmental variables which is a good solution for your requirement.

could you be more specific - I try to show my problem more specific:

I want to use in every 50 jobs 1 parameter (or maybe env variable as you said) but at the momement I have no parameters added in my jobs.

I want have name and meaning of my parameter the same in each job but I want to set different default values to them and assign diffrent values to them before runnig each jobs!!

I doubt tahat I can use env variable wchich has only 1 assigned value!!

adamski · Post by **adamski** » Thu Apr 28, 2005 7:04 am

Some more details would shed light on what it is you want to do. Odd having one param of the same name in all jobs with a different value for each. Could be a case for a multi threaded job?

One way to do this is export the jobs into a dsx file, edit it using search and replace routines to create params, then import. BE SURE TO KEEP A BACKUP.

chulett · Post by **chulett** » Thu Apr 28, 2005 7:27 am

Something like Parameter Manager from the fine folks who run this site could easily get your parameter into all of the jobs. However, if they all need different default values, you're still stuck with the monkey work of changing them all one by one.

martin · Post by **martin** » Fri Apr 29, 2005 11:30 am

Hi Luk,

I want to use in every 50 jobs 1 parameter (or maybe env variable as you said) but at the momement I have no parameters added in my jobs.

I want have name and meaning of my parameter the same in each job but I want to set different default values to them and assign diffrent values to them before runnig each jobs!!

This You Can Achive This With JobControl Job And Global Parameter File Where You Hardcode All Parameter Values. And JobControl Job At Runtime Will Pick Job Parameters from Parameter File.

Martin