To List IN CONDITIONS of all the jobs in a PARENT TABLE

All questions about Control-M jobs definitions
Post Reply
User avatar
MaheshDude
Nouveau
Nouveau
Posts: 28
Joined: 12 Dec 2011 12:00

To List IN CONDITIONS of all the jobs in a PARENT TABLE

Post by MaheshDude » 16 May 2016 5:03

Hi,

I have a requirement where in i need to list the IN/OUT conditions of all the jobs in a PARENT TABLE.

Is there any sql query to run and fetch the IN/OUT conditions from the CONDITIONS TABLE.

OR, any CTM Utility which i can use to get the result.

Thanks,

baralem

Re: To List IN CONDITIONS of all the jobs in a PARENT TABLE

Post by baralem » 23 May 2016 8:00

If you need to list the conditions of an specific folder you can use the following query (ctm server database):

SELECT jobname, condname,
rowtype,
CASE rowtype WHEN 'I' THEN 'IN_COND' WHEN 'O' THEN 'OUT_COND' WHEN 'D' THEN 'DO_CONDITION' ELSE rowtype END AS rowtype,
dateref, op
FROM cms_jobdef as jd, cms_con_j as cj
WHERE jd.jobno=cj.jobno
and schedtab='FOLDER_NAME'
order by 1,2;

regards.
Martin.

Post Reply