How to remove a parameter set from all the Jobs

Developer9 · Post by **Developer9** » Mon Dec 08, 2014 1:45 pm

We had a parameter set which is in almost all our jobs and we dont need it anymore, is there a way this can be deleted from all the jobs without going into each individual jobs?

ray.wurlod · Post by **ray.wurlod** » Mon Dec 08, 2014 4:14 pm

Other than by exporting the project, editing the export file, and re-importing, no.

Before you do that, it would be useful to perform a Where Used analysis on the Parameter Set in question, so that you have a better chance of not missing any.

If you'd like a really crazy way to effect this requirement, create an export file in XML format then write a DataStage job to process it!

boolseye · Post by **boolseye** » Mon Dec 22, 2014 3:13 am

Do the where-used analysis and identify jobs
export the jobs in dsx and change the param-sets to other local OR env variables.