Adding Job Parameters to All Jobs

asitagrawal · Post by **asitagrawal** » Wed Jul 11, 2007 10:15 am

Hi,

Is there any alternative way of adding new job parameters or including new Environment variables to all the existing jobs ??

ray.wurlod · Post by **ray.wurlod** » Wed Jul 11, 2007 10:39 am

Yes.

You can hack the DS_JOBOBJECTS table. Of course you would need to know the structure of this table, which is not documented. Further, since the parameters collection location within the record is not in the file dictionary for DS_JOBOBJECTS an SQL-based approach is not available; it would have to be programmatic.

You can export the job(s) with default properties, add the new parameters, the import the job(s) overwriting their existing counterparts.

Each approach has its own special dangers.

chulett · Post by **chulett** » Wed Jul 11, 2007 10:44 am

Parameter Manager.

The KBA Job Control Utilities.

kduke · Post by **kduke** » Wed Jul 11, 2007 7:22 pm

I don't think Dennis sells Parameter Manager any more. He sells Parameter Navigator instead.

chulett · Post by **chulett** » Wed Jul 11, 2007 7:34 pm

Hmm... ok, didn't realize that. Will Parameter Navigator do what the OP asks?

kduke · Post by **kduke** » Wed Jul 11, 2007 7:39 pm

It can do a lot more than that. It can change all parameter defaults in a project from DEV values to TEST values in one click after a little setup. That way someone does not update the wrong database by accident.

kduke · Post by **kduke** » Wed Jul 11, 2007 7:40 pm

I haven't spent a lot of time documenting all the features. Too much work. I would rather add value than sell more copies. You want it then buy it. It works well for me.