Urgent - Need SQL

ejtoedtli · Post by **ejtoedtli** » 07 Dec 2009 6:02

I have an urgent need to identify all Control-M jobs containing a particular parm (Set tab). I don't care what the "Var Name" is. I need to know all of the jobs that contain a particular "value". (It is a DNS name). I can not find a report in the reporting center that will support this. Therefore, I assume that I will need to run a query directly against the database. Can anyone suggest the SQL necessary? I do have the database diagram but I am not sure what I need and I have never coded SQL before.

This is for Control-M 6.3.01 running on Oracle.

Any quick help would be greatly appreciated!

Thanks.

baralem · Post by **baralem** » 07 Dec 2009 6:27

The following query should list the jobs that you need:

SELECT JOBNAME, SCHEDTAB
FROM CMS_JOBDEF WHERE JOBNO IN
(SELECT JOBNO FROM CMS_SETVAR WHERE VAREXPR = 'xxxxxx');

regards.
martin

ejtoedtli · Post by **ejtoedtli** » 07 Dec 2009 8:47

Thanks for the quick reply. This SQL worked perfect. Thanks You very much!