searching parameter value within all DS jobs

[eyabmo_rbc]

Hi All;

Is it possible to search a job parameter value within all DS jobs.

for example , if i have a user variable name : v_table_name with a value of : table_1 in one of my DS jobs , and i wanted to see all other DS jobs using that parameter value ,, how would i go about that ?

[ArndW]

Would you be looking for the default value in the job definition or the historical values actually used at runtime?

[ray.wurlod]

To paraphrase an old joke, if I were going there I would not be starting from here. This is something you really need to have planned for in advance, and used a tool such as Parameter Manager. About all you can do now is export the entire project and search the export file.

[eyabmo_rbc]

Would you be looking for the default value in the job definition or the historical values actually used at runtime? ...

am looking at the default value in the job definition

[chulett]

Export the project and search the resulting dsx file.

[eyabmo_rbc]

Export the project and search the resulting dsx file. ...

what i need is to be able to search within all projects , not just within 1 project , if that is possible.

[chulett]

Export all of your projects then.

[chulett]

If you want to get clever, build a job to pull the relevant parameter info out of the extract(s) and load it into a database - then query away!

[eyabmo_rbc]

If you want to get clever, build a job to pull the relevant parameter info out of the extract(s) and load it into a database - then query away! ...

when you have a project with 100 jobs its hard to trace , which job is this parameter belongs to ,, its gonna take long time i guess ,,

[chulett]

I have projects with several thousand jobs. Properly setup your search shouldn't take all that much time to do, especially if you are querying a database table you created just for this.