Oracle Alerts

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.. In this article, we will provide an overview of Oracle Alerts, its functionality, and usage and how they can be set up 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

1. Event alerts are triggered to execute based on pre-defined data conditions.
2. 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.

1. The CHECK step identifies necessary data points that are further used in the ACTION step.
2. 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.