Notifications of DBMS_SCHEDULER Jobs
By Martin | October 19th, 2008 | Category: 10g, 11g, Oracle Database | No Comments »Oracle is offering source code for notification of DBMS Jobs. The package can be downloaded from http://www.oracle.com/technology/products/database/scheduler/job_notification.zip. Although it is filed under 11g, it should work fine with 10gR2 as well.
With the package, you can get notifications if e.g. your GATHER_STATS_JOB did not finish within the maintenance windows and was aborted.