What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

-- Download How to get job execution statistics using repository tables. as PDF --


I have written few quries to fetch the status information of jobs

Fire these below queries against your repository database

—————————————————-

SELECT job_name, MAX (start_time), MAX (end_time)
FROM alvw_flow_stat
WHERE job_name = ‘XXXXX’
GROUP BY job_name, start_time, end_time
ORDER BY start_time DESC

—————————————————-

SELECT service AS job_name, start_time, end_time,
DECODE (status,
‘E’, ‘Error Occured’,
‘S’, ‘Started’,
‘D’, ‘Successfully Completed’,  status
) status
FROM al_history
ORDER BY start_time DESC

—————————————————-

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Leave a Reply

Your email address will not be published. Required fields are marked *


*