Scheduler Usage

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

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

Keep up the good work.

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