Is there a report or sql query for finding the last run date for Jobs and their schedules?
Release : ALL
Component : APPLICATIONS MANAGER
While there is no out of the box Report available for Job schedule's last run date, the below sql can be run as the Applications Manager Oracle user:
SELECT so_module as JOB, aw_sch_name as "Schedule Name", aw_active as Active, aw_last_rundate as "Last Run Date"
FROM so_job_table, aw_module_sched
WHERE so_job_table.so_job_seq=aw_module_sched.aw_job_seq
ORDER by aw_last_rundate;
Please note that the above query only provides results for Jobs that have schedules attached to them, both active and inactive.
This will not provide results for Jobs that do not have a schedule.