In and Out conditions of the jobs

nanali · Post by **nanali** » 12 Jun 2010 7:52

Hi,
Can we export the In and Out conditions of all the control-m jobs in to an excel sheet automatically?

hipikll · Post by **hipikll** » 13 Jun 2010 8:19

have a look to cms_cond_j table of server DB. (as i remember)

Or make a job, which will extract all of the jobs definition from server/EM and then use unix 'buildin' text parsers to get conditions.

All of these processes can be automated.

And even, i havent never do it, but in Reporting Facility, there is one template about conditions ... (correct me if i'm wrong)

jchannel · Post by **jchannel** » 14 Jun 2010 2:38

On CTM/EM 6.4.400 you can select Tools --> Prerequisite Conditions and apply your filter and then use File --> Export to export them to Excel.

It stores them in a default named worksheet name PrerequisiteConditions.xls. Not sure when this became available.

J