Oracle Alerts

 

Oracle Alerts

Contents

Chapter 1 : Overview of Oracle Alerts

Chapter 2 : Defining Alerts

Chapter 3 : Type of Alerts

Chapter 4 : Check the Alerts

OverView of Oracle Alerts:

• Keep you informed of critical activity in your database
• Deliver key information from your applications, in the format you choose
• Provide you with regular reports on your database information
• Automate system maintenance, and routine online tasks

Overview:

Oracle Alert is your complete exception control solution.

Oracle Alert facilitates the flow of information within your organization by letting you create entities called alerts to monitor your business information and to notify you of the information you want. You can define one of two types of alerts: an event alert or a periodic alert.

An event alert immediately notifies you of activity in your database as it occurs. When you create an event alert, you specify the following:

• A database event that you want to monitor, that is, an insert and/or an update to a specific database table.
• A SQL Select statement that retrieves specific database information as a result of the database event.
• Actions that you want Oracle Alert to perform as a result of the database event. An action can entail sending someone an electronic mail message, running a concurrent program, running an operating script, or running a SQL statement script. You include all the actions you want Oracle Alert to perform, in an action set.

A periodic alert, on the other hand, checks the database for information according to a schedule you define. When you create a periodic alert, you specify the following:

• A SQL Select statement that retrieves specific database information.
• The frequency that you want the periodic alert to run the SQL statement.
• Actions that you want Oracle Alert to perform once it runs the SQL statement. An action can entail sending the retrieved information to someone in an electronic mail message, running a concurrent program, running an operating script, or running a
• SQL statement script.

Note : For More Information please download the below link
http://www.ziddu.com/download/15525590/OracleAlerts1.pdf.html