DSXchange

Hi,

I have 2000 jobs in 35 main categories. I know the output file name. But I want to find the job name which is creating the file.
Is there any way to find or mannualy we have to search it...


Thanks in advance
Parameswar

viewtopic.php?t=116323

Modify the SQL for your requirement.

Search for more.

This is the purpose of Usage Analysis. Select the table definition in question (using Manager client), then select Usage Analysis from the toolbar on the menu. Usage Analyis produces a list of the jobs that use that table definition, including the columns that are used in each job.

You do need, however, to have been punctilious in managing your table metadata for Usage Analaysis to work properly. That is, table definitions are properly imported or saved into the Repository.