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,
To List IN CONDITIONS of all the jobs in a PARENT TABLE
- MaheshDude
- Nouveau
- Posts: 28
- Joined: 12 Dec 2011 12:00
Re: To List IN CONDITIONS of all the jobs in a PARENT TABLE
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.
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.