How to Find name of the Job

mujeebur · Post by **mujeebur** » Mon Mar 20, 2006 11:28 am

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 ?

ArndW · Post by **ArndW** » Mon Mar 20, 2006 11:40 am

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.

chucksmith · Post by **chucksmith** » Mon Mar 20, 2006 5:06 pm

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.