Description
If you have Oracle Scheduler jobs running and want to be notified when one of those jobs runs long, this alert will help. A long running job in this case is defined as one that is currently running and has exceeded 2 standard deviations of its average execution time. This alert uses 14 days of history to calculate the average.
Alert Definition
Create a Custom Alert of type "Custom SQL Alert - Multiple Numeric Return", copy/paste in the attached SQL statement and make it look similar to this:
