Finding Tables Accessed in Jobs

SGT · Post by **SGT** » Tue May 04, 2004 1:03 pm

I need to find out all the jobs in a project which accesses a particular Database table.
What is the easiest way to get this list?
Thanks,
SGT

kduke · Post by **kduke** » Tue May 04, 2004 3:10 pm

You need either Reporting Assitant or MetaStage. Do a search. Both have been covered. Let us know if you still cannot figure it out.

chulett · Post by **chulett** » Tue May 04, 2004 3:14 pm

Failing that, you could also export the project and then search for the table name in the file.

ray.wurlod · Post by **ray.wurlod** » Tue May 04, 2004 4:42 pm

It gets really ugly if the table names are job parameters!

mhester · Post by **mhester** » Tue May 04, 2004 4:50 pm

If you have followed some kind of standard for naming and saving table definitions you might try usage analysis for Manager. You can right click on an object and choose usage analysis. Maybe this will help you too.

Regards,

Michael Hester

SGT · Post by **SGT** » Tue May 04, 2004 6:48 pm

Unfortunately there is no proper standard where we used table definitions. But the table names are hardcoded.

rasi · Post by **rasi** » Tue May 04, 2004 7:40 pm

If the table is hardcoded then the best way is to export to dsx file and search for the table name to get the jobs used for that particular table.

Siva

kduke · Post by **kduke** » Wed May 05, 2004 8:03 am

The tablenames are stored in either DSLinks.InpTableFileSPName, DSLinks.OutputFileSPName in the doc_tool.mdb or in DSProperties.PropValue where PropName like "TABLE*" or *TABLES".

If you need more then let me know.