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
Total time taken by each job
- pmdeshayes
- Nouveau
- Posts: 23
- Joined: 07 Jul 2008 12:00
Hi, I use this query to get run times. (found it on this forum a while back. )
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
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