Total time taken by each job

A lot of scripts ans example to extract information from Control-M tools.
Post Reply
User avatar
Shahab
Nouveau
Nouveau
Posts: 1
Joined: 07 Sep 2011 12:00

Total time taken by each job

Post by Shahab » 07 Sep 2011 10:09

Hi,

I am trying to add 1 more cloumn in my report to view the total time taken by each job. By default this is not included in the reporting facility. Can anyone help me out in achieving this requirement.

With regards
Shahab

User avatar
pmdeshayes
Nouveau
Nouveau
Posts: 23
Joined: 07 Jul 2008 12:00

Post by pmdeshayes » 27 Sep 2011 6:39

Report Facility has its limits. Use a SQL query to retrieve this information from either RUNINFO_HISTORY (EM database) or CMR_JOBINF (SV database).

User avatar
ahtisham454
Nouveau
Nouveau
Posts: 23
Joined: 16 Feb 2012 12:00

Post by ahtisham454 » 23 Feb 2012 11:16

Keep up the good work.

User avatar
jstarkw
Nouveau
Nouveau
Posts: 58
Joined: 14 Jan 2010 12:00

Post by jstarkw » 27 Feb 2012 2:11

Hi, I use this query to get run times. (found it on this forum a while back. :D )

select substring(TIMESTMP,1,8)as DATE,JOBNAME, cast((ELAPTIME/6000.00)as decimal(6,2)) as MINUTES
from CMR_RUNINF
where CMR_RUNINF.SCHEDTAB='name of scheduling group'
and CMR_RUNINF.TIMESTMP > 20100601000000
order by JOBNAME,TIMESTMP

Should be very easy to modify to meet your needs.

i

Post Reply