Is there are a way to increase duration?
select
trunc(a.start_time) start_date
,b.target_name
,a.job_name as job_name
,a.end_time as end_time
,a.start_time as start_time
,a.status as status
,max(a.start_time) over (partition by a.job_name order by
trunc(a.start_time)) as last_time
from mgmt$job_execution_history a, mgmt$job_targets b where
b.target_name IS NOT NULL
)
where
start_time=last_time
and start_date>trunc(sysdate)-8
order by target_name, start_time
.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc)
remove NSPAM to email
Received on Mon Aug 13 2007 - 13:06:54 CDT
