This content has been marked as final. Show 6 replies
Hello;1 person found this helpful
This one I like :
it's doesn't gives you the status failed or completed?
Tough to pull everything I would want in a single query.
select db_name, start_time, end_time, status, time_taken_display, output_bytes_display, output_device_type, session_key, session_recid, session_stamp from rc_rman_backup_job_details where end_time > sysdate -1
Thanks alot :)
The following query works for me:1 person found this helpful
select db_name,start_time,end_time,substr(to_char(cast(end_time as timestamp)-cast(start_time as timestamp),'HH:MI:SS'),12,8) "Execution_Time ",status
where start_time >sysdate -1
order by start_time desc;
Note that the query will not give you jobs that did not execute.