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 ?
How to Find name of the Job
Moderators: chulett, rschirm, roy
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.
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
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.
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.
Chuck Smith
www.anotheritco.com
www.anotheritco.com