Page 1 of 1

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

Posted: Thu Dec 20, 2012 1:37 pm
by vishu19aug
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

Posted: Thu Dec 20, 2012 4:14 pm
by ray.wurlod
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.

Posted: Thu Dec 20, 2012 5:25 pm
by rameshrr3
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 .