To find jobs which are using a Particular Table

akhiln · Post by **akhiln** » Mon Nov 29, 2004 2:03 pm

Hi All,

Is it possible to find out the jobs which are using a particular table. I have a table like this "S_F0456". I want to know in which are all the jobs this particular table is used.

Is there any commands that i can use it from the Administrator to find out the jobs or any other way of finding it.

Expecting a positive reply.

Thanks & Regards,
Akhil

KeithM · Post by **KeithM** » Mon Nov 29, 2004 2:33 pm

This topic has been discussed many times before. You can do a search on 'table usage' or just check out this post.

kduke · Post by **kduke** » Mon Nov 29, 2004 3:32 pm

Look at viewtopic.php?t=89892 as well.

akhiln · Post by **akhiln** » Mon Nov 29, 2004 4:06 pm

Thanks Keith & Kim Duke

chucksmith · Post by **chucksmith** » Mon Nov 29, 2004 4:31 pm

Take a look at my List all files and tables used by jobs in a dsx file tool. You will find it on the DataStage Tools page of www.anotheritco.com.

Since you are on a Windows server, you may have to change the line termination setting on the input sequential file stage to read your dsx file after you copy it to your server.

akhiln · Post by **akhiln** » Mon Nov 29, 2004 5:14 pm

Thank you so much Chuck Smith. I am using the tool developed by you to get the required information

chucksmith · Post by **chucksmith** » Mon Nov 29, 2004 5:20 pm

You are very welcome. :D