searching parameter value within all DS jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 10
- Joined: Tue Nov 20, 2007 7:15 am
- Location: CANADA
searching parameter value within all DS jobs
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 ?
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 ?
E.M
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 10
- Joined: Tue Nov 20, 2007 7:15 am
- Location: CANADA
-
- Participant
- Posts: 10
- Joined: Tue Nov 20, 2007 7:15 am
- Location: CANADA
-
- Participant
- Posts: 10
- Joined: Tue Nov 20, 2007 7:15 am
- Location: CANADA
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 wrote: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! ...
E.M