Oracle Alerts - For the beginners only

Contents

• What is Oracle Alert?
• What are the difference types of Alert?
• How to set up an Alert?
(Different components of Alert)
• How Alert Works?
• Limitations of Oracle Alert?

What is Oracle Alert?
• Complete exception control solution
• Easy electronic emailing
• Execution of process
• Schedule in regular interval
• Replacement of Database Trigger
• Take predefined actions
• Take actions depends on user response.

Alerts
• Periodic Alert • Event Alert
– Variable frequency – All possible events
• Customized Alert Frequency
• Customized Alert Actions
(Details / Summary action, No exception, History, Duplicate Checking
• Action Escalation
• Response Processing

Creating a Periodic Alert
• Set Frequency (On Demand, On day of …)
• Set time / interval
• Enter / import select statement
• Verify / Run select statement

Note : For More Information please download the below link

http://www.ziddu.com/download/15525611/OracleAlerts2.pdf.html

Thanks,
Raju