DSXchange

Posted: **Thu Aug 28, 2008 3:59 am**

Hi,

Please help me with this below requirement.

Is that possible for me to run commands in command page of administrator and identify a job which uses a particular table name?

ex: if a table EMP_NO is used in one job employee_test, can i find this job name employee_test by running a command in Admin, i have huge list of jobs and manually searching it takes a lot of time for me, i tried using command LIST DS_JOBS which gave me all the jobs in a particular project, i am not aware of teh syntax to use to find solution for my above requirement. please help.

Thanks.

Posted: **Thu Aug 28, 2008 4:35 am**

Code: Select all

SELECT NAME FMT '32L', CATEGORY FMT '32L' FROM DS_JOBS
WHERE JOBNO IN
(SELECT OBJIDNO FROM DS_JOBOBJECTS
 WHERE EVAL "@RECORD" LIKE '%EMP_NO%');

DSXchange

Running Commands in DS Administrator

Running Commands in DS Administrator