Page 1 of 1

How to Find name of the Job

Posted: Mon Mar 20, 2006 11:28 am
by mujeebur
I am sorry , I did search , but could not find exatcly what I need , if its already answered.

How to find the JobName which generetes Hashed file ?

Posted: Mon Mar 20, 2006 11:40 am
by ArndW
If you correctly used the table column layout in the Manager you can right-click on that to see which jobs used those definitions. You could also do a search in a full project .DSX export file for the hashed file name and then look up a couple of lines to get the corresponding job name. If you used a parameter for either the path or file name then things are a lot more complex.

Posted: Mon Mar 20, 2006 5:06 pm
by chucksmith
You can use my List all files and tables used by jobs in a dsx file to create an inventory of your files and tables by job. You can use the resulting csv file to track jobs that use a file.

To best use the tool, create a dsx file with just job designs and routines (including source).

You will find this and other tools on the DataStage Tools page of www.anotheritco.com.