Find all jobs in a proj using certain hash file.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
zulfi123786
Premium Member
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

Find all jobs in a proj using certain hash file.

Post by zulfi123786 »

Hi,

I have a project containing about 250 jobs and i need a list of jobs using the hash file 'xyz.hs' , how can i find this ????

Same as above case but using a seq file 'xyz.dat', how to know the job names???
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Is the name hard-coded in the job ?
zulfi123786
Premium Member
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

Post by zulfi123786 »

Yes it is hard coded.
miwinter
Participant
Posts: 396
Joined: Thu Jun 22, 2006 7:00 am
Location: England, UK

Post by miwinter »

Export the jobs from the project and run a command/script over them to return the job names where a match is made. There may be a method you can use over the back-end Universe tables too, though I'd doubt whether that level of job detail is held in there.
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Chuck Smith has some tools that would help. For this, specifically the 'List all files and tables' one - I've tweaked my copy to load the results into a database table so it can be easily queried.
-craig

"You can never have too many knives" -- Logan Nine Fingers
mf_arts
Participant
Posts: 21
Joined: Wed Oct 19, 2005 5:10 am
Location: Dublin

Post by mf_arts »

In DS 8.x you have a a feature called Impact analysis that would solve your probelem, however, as you are working with version 7.x you need to do some extra work.
I should do the follow:
1 - Create a customized .xsl file (stylesheet) to transform the xml
2 - Export the project to xml, during the export process you have to select your customized xsl file (made on step 1), to select the your .xsl file, press the options button (export options) and in the tree under XML node you'll see a stylesheet option, activate the flag "include the reference to style sheet in document" and in Reference point to the.xsl file path then Export the project.
3 - once the project is exported to XML open the XMl file with Internet explorer, in my case I export this to pdf files.
4 - If you have problems to create the .xsl, let me know.
I can't remember if all steps are exacly the same in version 7.x as I don't work with this version for a couple years.
zulfi123786
Premium Member
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

Post by zulfi123786 »

Is there not any meathod with the UV tables???
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Sure, search the forums here for DS_JOBOBJECTS and you should find something close that you could adjust to suit your need.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply