|To List IN CONDITIONS of all the jobs in a PARENT TABLE
|Page 1 of 1|
|Author:||MaheshDude [ 16 May 2016 5:03 ]|
|Post subject:||To List IN CONDITIONS of all the jobs in a PARENT TABLE|
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.
|Author:||baralem [ 23 May 2016 8:00 ]|
|Post subject:||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,
CASE rowtype WHEN 'I' THEN 'IN_COND' WHEN 'O' THEN 'OUT_COND' WHEN 'D' THEN 'DO_CONDITION' ELSE rowtype END AS rowtype,
FROM cms_jobdef as jd, cms_con_j as cj
order by 1,2;
|Page 1 of 1||All times are UTC+01:00|
|Powered by phpBB® Forum Software © phpBB Limited