2 questions

[catchtony]

Hello all,

Can you please help me in finding out how many jobs in different tables have the force by parameter in their steps tab ? what is the easiest way ?

Also can we get to know who deleted the table from Control-M desktop ?

Thanks in advance for the help.

[baralem]

Try this query:

SELECT JOBNAME, SCHEDTAB, APPLIC
FROM CMS_JOBDEF, CMS_DO
WHERE CMS_JOBDEF.JOBNO=CMS_DO.JOBNO
AND RTRIM(ACTION)='FORCEJOB'


regads
martin