Page 1 of 1

How to remove a parameter set from all the Jobs

Posted: Mon Dec 08, 2014 1:45 pm
by Developer9
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?

Posted: Mon Dec 08, 2014 4:14 pm
by ray.wurlod
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!

Posted: Mon Dec 22, 2014 3:13 am
by boolseye
Do the where-used analysis and identify jobs
export the jobs in dsx and change the param-sets to other local OR env variables.