DSXchange

Posted: **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

Posted: **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.

Posted: **Mon Nov 29, 2004 3:32 pm**

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

Posted: **Mon Nov 29, 2004 4:06 pm**

Thanks Keith & Kim Duke

Posted: **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.

Posted: **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

Posted: **Mon Nov 29, 2004 5:20 pm**

You are very welcome. :D

DSXchange

To find jobs which are using a Particular Table

To find jobs which are using a Particular Table