table usage analysis

sri75 · Post by **sri75** » Mon May 14, 2007 8:22 am

HI,

I have 100 jobs in one project.We used one table as source in many jobs.I wanted to find all jobs ,thatt used the particular table as source.
We don't have any table definitions, so I saved table definition in repository under Saved category.I did usage analysis on this table definition,but it was not able to find any.

I tried with chuck smith's custom dsx file to find all jobs.
but it is giving table name and routine names in that particual job only.Can you please advice me how to use this custom job

Thanks

chulett · Post by **chulett** » Mon May 14, 2007 8:42 am

Doing the table metadata after the fact is too late.

For Chuck's utility, I load the output into a database table. Then you can simply query the field that contains your table (FILETABLENAME?) with a case insensitive wildcard match.

sri75 · Post by **sri75** » Mon May 14, 2007 8:56 am

Thanks Craig.You mean ,do I need to run all 100 dsxs using the custom job

chulett · Post by **chulett** » Mon May 14, 2007 9:05 am

I pull a single .dsx file with source from an entire project and load that. Simplest that way.

sri75 · Post by **sri75** » Mon May 14, 2007 1:27 pm

Craig,

The way you suggested to get the table names worked fine .Thanks