Notifications of DBMS_SCHEDULER Jobs

Oracle is offering source code for notification of DBMS Jobs. The package can be downloaded from 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.

Leave Comment