« E-mail reports for Oracle Scheduled Jobs | Main
Wednesday
Dec292010

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

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>