Tuesday 6 September 2011

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

No comments:

Post a Comment