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

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