Page 1 of 1
Finding Tables Accessed in Jobs
Posted: Tue May 04, 2004 1:03 pm
by SGT
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
Posted: Tue May 04, 2004 3:10 pm
by kduke
You need either Reporting Assitant or MetaStage. Do a search. Both have been covered. Let us know if you still cannot figure it out.
Posted: Tue May 04, 2004 3:14 pm
by chulett
Failing that, you could also export the project and then search for the table name in the file.
Posted: Tue May 04, 2004 4:42 pm
by ray.wurlod
It gets really ugly if the table names are job parameters!
Posted: Tue May 04, 2004 4:50 pm
by mhester
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
Posted: Tue May 04, 2004 6:48 pm
by SGT
Unfortunately there is no proper standard where we used table definitions. But the table names are hardcoded.
Posted: Tue May 04, 2004 7:40 pm
by rasi
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
Posted: Wed May 05, 2004 8:03 am
by kduke
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.