Scheduler Usage
http://scheduler-usage.com/

To List IN CONDITIONS of all the jobs in a PARENT TABLE
http://scheduler-usage.com/viewtopic.php?f=29&t=4114
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

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,

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,
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.

Author:  fizzpop [ 01 Jun 2016 3:25 ]
Post subject:  Re: To List IN CONDITIONS of all the jobs in a PARENT TABLE

If you are using Mainframe ControlM, see my free utility in "scripts"
This also compares "in" to "out" conditions, looking for mistakes.

Page 1 of 1 All times are UTC+02:00
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/