JobNames and DataStores Info in BackEnd

[Former Member]

Hi,

We have a sql server backend for BODS.

I would like to get the information of all the jobs and DataSteores information in Central repository.

Do we have any table in the back end to find this info ?

Do we have any doc, which says all the default tables that comes when we have sql server repository.

[former_member186897 · Accepted solution]

Sai v,

You can do it by reading through repository metadata. Below are excellent articles on how to use metadata tables. Hope this helps.

Data Services Metadata Query Part 1

http://www.dwbiconcepts.com/etl/23-etl-bods/171-data-services-metadata-query-part-2.html

Regards,

Ansari MS

[former_member205887]

Hi Sai,

Check alvw_parent_child

-- Balakrishna

[Former Member]

HI Sai V,

Go through the below threads it may be helpfull for you..

Thanks,

Subbu CH.