To find the job name from the Output File name

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
parameswar
Premium Member
Premium Member
Posts: 66
Joined: Sun Apr 08, 2007 12:34 pm

To find the job name from the Output File name

Post by parameswar »

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
ag_ram
Premium Member
Premium Member
Posts: 524
Joined: Wed Feb 28, 2007 3:51 am

Post by ag_ram »

viewtopic.php?t=116323

Modify the SQL for your requirement.

Search for more.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply