Scheduler Usage

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,

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.