Need a start/end time report with extras.

[Hubba]

I'm trying to create a report of all my production jobs that actually have hardcopy print associated with them with job start and end times.. I have identified these jobs and was looking for some way to mark these in Control-M. I was thinking of adding a quantitative resourse called print. I need to create a report that will identify the job and supply start.end times for these jobs. Average run time would be nice too. Any suggestions?

[nbarr007]

Hi I use the following SQL query. We probably need the the help of a DBA to set up.

select distinct JOBNAME, schedtab
, to_char(to_timestamp(trim(timestmp)
, 'YYYYMMDDHH24MISS') - numtodsinterval(elaptime / 100
, 'SECOND'), 'YYYY-MM-DD HH24:MI:SS') as start_time
, to_char(to_date(trim(timestmp), 'YYYYMMDDHH24MISS')
, 'YYYY-MM-DD HH24:MI:SS') as end_time
, substr(to_char(numtodsinterval(elaptime / 100, 'SECOND')
, 'HH24:MI'), 12, as duration
from CMR_RUNINF
where timestmp like '20091120%'
order by schedtab asc;

[fyot]

Another suggestion,

You should see APS Manager Console product from APS Enterprise.
You will provide to users a web access to see jobs using some filters, and providing too, a way to save and send the result by mail.