In this article we will provide an overview of Oracle Alerts, its functionality and usage and how they can be setup and triggered.
- Oracle Alert is a flexible, automated, exception management and reporting tool that can be defined to execute certain actions based on other data occurrences in the database.
- Oracle Alert allows you to define actions to be taken when highly specific conditions/exceptions occur in the database
- Alerts can be driven by events, or driven by a periodic schedule
- Resulting alert actions can consist of sending email messages, manipulating data through SQL programs, or running OS scripts
- Responses to alert email messages can be received and processed by the Oracle Alert manager
- Alert distribution lists can be defined for email recipients.
Features of Periodic & Event Driven Alerts
- Event alerts are triggered to execute based on pre-defined data conditions.
- Periodic alerts can be configured to execute as often as you need during a 24-hour period, once per week or once per month.
Alerts consist of a CHECK and an ACTION step.
- The CHECK step identifies necessary data points that are further used in the ACTION step.
- The ACTION step can send the necessary data to an email system, or can further update database values as a result of the triggering event or the data values returned from the CHECK step.
Alert Response management:
- Email responses can be processed by Oracle Alert.
- Valid response values can be pre-defined by Oracle Alert.
- Actions can be taken by Oracle Alert based on the values in the response.
- No response or invalid values can be actioned accordingly.