reporting

catchtony · Post by **catchtony** » 16 Jun 2010 3:23

Hi... is there any way to email a daily report of all the jobs on all the Datacenters in Control-M UNIX version 6.2 viz jobs on hold, failed jobs, some particular jobs coming into that day AJF ?

baralem · Post by **baralem** » 16 Jun 2010 7:29

You can use ctmpsm or query database tables.

ctmpsm has a lot of options:

ctmpsm -CHILD <orderid> [<tasktype>]
tasktype:B=JOB, D=DETACHED, C=COMMAND, U=DUMMY, X=EXTERNAL

ctmpsm -IMPORT_CAL <ECS> [OVERWRITE]

ctmpsm -LISTCAL [<Calendar>] [<Calendar>]

ctmpsm -LISTALL [<ODAT>] [-SORT <ORDERID>]

ctmpsm -LISTJOB <OK> [-SORT <ORDERID>]

ctmpsm -LISTGROUP <application> <group> [<scheduling>]

ctmpsm -LISTAJFTAB <table>

ctmpsm -SCHEDTAB <-LISTTABLE <table>|-UPDATE <row_number> <udaily>|-ADD <table> <udaily_name>|-DUDAILY <row_number>|-REMOVE <table>|-LISTJOBS <row_number> >

ctmpsm -LISTSYSOUT <orderid> [-SYSOUTNUMBER <number>]
ctmpsm -LISTDETAILS <orderid>
ctmpsm -LISTFULLDETAILS <orderid>

ctmpsm -UPDATEAJF <orderid> <HOLD|FREE|DELETE|UNDELETE|RERUN|CONFIRM|FORCEOK|STATISTICS|CONDADDIN <cond> <date> <AND>|CONDADDOUT <cond> <date> <+|->|CONDDELIN <cond>|CONDDELOUT <cond>

ctmpsm -FULLUPDATE <orderid>
[ -GROUP <group> ]
[ -APPLICATION <applic> ]
[ -NODEGRP <name> ]
[ -MEMLIB <path> ]
[ -MEMNAME <filename> ]
[ -CMDLINE <string> ]
[ -OWNER <username> ]
[ -MAXRERUN <value> ]
[ -TIMEFROM <earliest> ]
[ -TIMEUNTIL <latest> ]
[ -TIMEZONE <time> ]
[ -PRIORITY <job> ]
[ -CRITICAL Y|N ]
[ -CYCLIC Y|N ]
[ -INTERVAL <45d> ]
[ -OVERLIB <alternative> ]
[ -MAXWAIT <days> ]
[ -INCOND <condition> <dateref>|ODAT AND|OR ]
[ -OUTCOND <condition> <dateref>|ODAT ADD|DEL ]
[ -AUTOEDIT <varname> <expression> ]

ctmpsm -UPDATEGROUP <application> <group> <HOLD> [<scheduling>]

ctmpsm -UPDATETABLE <table> <HOLD>
ctmpsm -XML [<ODAT>] [-SORT <ORDERID>]

regards
martin

catchtony · Post by **catchtony** » 17 Jun 2010 7:20

Thanks, here is exactly the situation. We have Control-M running on both EM(Unix) and MVS (Mainframes). So the MVS jobs have the image on EM to which I mean to say is that all the MVS jobs can been seen in Control-M/EM in the AJF only. I don't know the concept behind this but I had seen that if I free/hold/rerun that MVS image on EM, it actually reflects on MVS. So the idea here as we need have a report at the end of the day from Control-EM which shows all the jobs of MVS image if any of them are in HOLD status.
These MVS images run on the server SB-IBM on Control-M/EM.

Thanks again for the reponse.