Reporting on latest run of Oracle Scheduled Jobs

Update:

I've found that the TIMESTAMP data type on the LOG_DATE column is a bit tedious to sort.  So here's a complete example query of how you'd get the latest run results for a specified job.  Note that I implemented a subquery to get the sort to work with intended results. 

As written you'll get the latest results (job_name, status, log_date, and run_duration columns) for the job "MY_job".

Cheers

declare MYrecipients varchar2(200) := 'tallarico@ryanboyer.net'; MYsubject varchar2(100) := 'Run Results for MY_JOB'; MYcolumns varchar2(200) := '<tr><table border=1><th>Job Name</th><th>Status</th><th>Log Date</th><th>Run Duration</th></tr>'; cursor c1 is select job_name, status, log_date, run_duration from dba_scheduler_job_run_details where rownum = 1; type MYresults is table of c1%rowtype; allMYresults MYresults; xmessage varchar2(32767); begin select job_name, status, log_date, run_duration BULK COLLECT INTO allMYresults from ((SELECT job_name, status, log_date, run_duration FROM DBA_SCHEDULER_JOB_RUN_DETAILS WHERE FirstColumn = 'MY_JOB' order by log_id desc)) where rownum <= 5; xmessage := '<b>Here are the most recent run results for MY_JOB:</b><p>' || MYcolumns || '<p>'; for i in allMYresults.first..allMYresults.last loop xmessage := xmessage || '<tr><td>' || allMYresults(i).job_name || '<td>' || allMYresults(i).status || '<td>' || allMYresults(i).log_date || '<td>' || allMYresults(i).run_duration || '</td></tr>'; end loop; sys.utl_mail.send( 'System.Generated@RyanBoyer.net', MYrecipients,null, null, MYsubject, xmessage, 'text/html; charset=us-ascii', 3); END;