Finding all jobs which are using a perticular table

Madhu1981 · Post by **Madhu1981** » Sat Feb 09, 2008 3:31 pm

Hi,

I have a scenario where i need to find the all jobs which are using a particular oracle table either as source or target.

Eg: I have a table called EMP, now i would like to know all the jobs which are using EMP table. Is there any way to find out?

Thanks in advance
Madhu

lstsaur · Post by **lstsaur** » Sat Feb 09, 2008 4:01 pm

Not possible from DataStage. MetaStage can provide that kind of info.

chulett · Post by **chulett** » Sat Feb 09, 2008 4:09 pm

Actually it is through various means and it has been discussed here a number of times. A quick search found several topics, I know there are plenty more out there.

viewtopic.php?t=116343
viewtopic.php?t=116030
viewtopic.php?t=110476
viewtopic.php?t=109051
viewtopic.php?t=108675
viewtopic.php?t=100395

Note these are general 'how do I find' posts, not necessarily exact answers to the poster's question. They should get them started, however.

ray.wurlod · Post by **ray.wurlod** » Sat Feb 09, 2008 4:14 pm

Usage Analysis on the EMP table definition.

chulett · Post by **chulett** » Sat Feb 09, 2008 4:21 pm

I think that's mentioned in pretty much every post I linked.