Need a start/end time report with extras.
Need a start/end time report with extras.
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?
Batch run times
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;
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;