Page 1 of 1
Posted: 20 Jul 2009 9:13
by GNappo
Hi Jakep,
You can use "Reporting Facilities" through the "emreportcli" utility.
Would you please look at "CONTROL-M/Enterprise Manager User Guide" documentation.
Best Regards
Giuseppe Nappo
Posted: 21 Jul 2009 11:16
by philmalmaison
hy,
statistics are made by controlm servers about there own jobs.
common way is to use both ctmpsm and ctmruninf utilities.
regards
philmalmaison
SQL of course...
Posted: 22 Jul 2009 12:35
by th_alejandro
Try this ....
SELECT a.nodeid||'|'||
b.applic||'|'||
b.applgroup||'|'||
a.jobname||'|'||
a.runcount||'|'||
to_date(a.startrun, 'YYYYMMDDHH24MISS')||'|'||
to_date(a.endrun, 'YYYYMMDDHH24MISS')||'|'||
trunc((to_date(a.endrun, 'YYYYMMDDHH24MISS')-to_date(a.startrun, 'YYYYMMD
DHH24MISS'))*24*60*60)||'|'
FROM ctmuser.cmr_jobinf a,
ctmuser.cmr_ajf b
WHERE a.orderno = b.orderno
AND b.odate = '&1'
AND a.oscompstat = 0
ORDER BY a.jobname, a.runcount ;
You can change oscompstat field value as you need. Replace &1 with odate required. This SQL is designed for Oracle, adjunt sintax for other database engines.
Posted: 12 Apr 2010 5:27
by master4usrcm
You can use Select * from CMR_STATIS;...with this you can get all the details.