Need to list the jobs using a same file(filename)

vishu19aug · Post by **vishu19aug** » Thu Dec 20, 2012 1:37 pm

Hi,

I have a situation. One of my job is writing data to a dataset, now i need to find all the jobs using the same file.

How to do that? Please help

Thanks,
Vishal Gupta

ray.wurlod · Post by **ray.wurlod** » Thu Dec 20, 2012 4:14 pm

Assuming that you have been vigilant about your metadata (table definitions), right click on the table definition of the Data Set in your repository and perform a Where Used analysis.

rameshrr3 · Post by **rameshrr3** » Thu Dec 20, 2012 5:25 pm

Export all yiour jobs to a dsx file and search for the exact name of your dataset using Find. you will get a clue which jobs use it .