Oracle Alerts Overview

Oracle Alert facilitates the flow of information within your organization by letting you
create entities called alerts to monitor business information and to notify you of the
information you want.
Two types of alerts:
1. Event Alert
2. Periodic Alert

1. Event Alert:-
An event alerts are triggered/fired or notifies you of activity when some changes occures in data in the database. When we create an event alert -

1. A database event that we want to monitor, an insert or an update event on a specific database table.
2. A SQL Select query/statement which fetch specific database information as a result of that database event.
3. Define actions which we want alert to perform as a result of the database event.
An action can entail sending someone an email, submit a concurrent program, operating script and SQL statement script running,. We include all the actions which are we want Oracle Alert to perform, in an action set.

2. Periodic Alert:-
A periodic alert checks the information according to a schedule we define.
Periodic alerts are triggered/fired hourly, daily, weekly, monthly or yearly based on schedule we define or input.
When we create an periodic alert -

1. A SQL Select query/statement that retrieves specific database information.
2. Define or set frequency that you want the periodic alert to run the SQL statement.
3. Define actions which we want alert to perform as a result of the database event.
An action can entail sending someone an email, submit a concurrent program, operating script and SQL statement script running,. We include all the actions which are we want Oracle Alert to perform, in an action set.