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.