Find Jobs which Use a Particular Env Variable.

DeepakCorning · Post by **DeepakCorning** » Wed Jan 17, 2007 12:06 pm

I just wanted to know that is there a way to find out all the jobs which use a Particular Environment Variable??
For EG. If I have 50 Jobs and 25 of them use Environment variable DATABASE_TYPE then is there way to get list of all those tables??

ray.wurlod · Post by **ray.wurlod** » Wed Jan 17, 2007 3:49 pm

Nothing out of the box. You could use something like Kim Duke's parameter navigator to search, or a search on DS_JOBS and DS_JOBOBJECTS modelled on some of the queries posted here.

DeepakCorning · Post by **DeepakCorning** » Wed Jan 17, 2007 4:29 pm

Can you provide me some links...I will try to search as well.. THanks..

I_Server_Whale · Post by **I_Server_Whale** » Wed Jan 17, 2007 4:37 pm

Kim Duke's website, where you can learn more about 'Parameter Navigator'. http://Duke-Consulting.com.

kumar_s · Post by **kumar_s** » Wed Jan 17, 2007 4:44 pm

Very recently we had discussion on that. Kim had posted such code

Code: Select all

SELECT
   DS_JOBS.NAME AS JOB_NAME,
   DS_JOBS.CATEGORY,
   DS_JOBOBJECTS.NAME AS OBJECT_NAME,
   DS_JOBOBJECTS.OLETYPE,
   EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'DATABASE_TYPE',1) > 0 then 'FOUND' else ''" AS FOUND FMT '5L'
FROM
   DS_JOBS,
   DS_JOBOBJECTS
WHERE
   DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO
   and FOUND = 'FOUND'
GROUP BY
   JOB_NAME,
   DS_JOBS.CATEGORY,
   OBJECT_NAME,
   DS_JOBOBJECTS.OLETYPE,
   FOUND
;

kduke · Post by **kduke** » Wed Jan 17, 2007 6:59 pm

Three mentions in one post and I don't even have to answer the post. Thanks.

kumar_s · Post by **kumar_s** » Wed Jan 17, 2007 7:01 pm

That shows how popular Kim and Kim's code are.