Module 15 Monitoring SQL Server 2008 R2 with Alerts and Notifications. Module Overview. Configuration of Database Mail Monitoring SQL Server Errors Configuring Operators, Alerts and Notifications. Lesson 1: Configuration of Database Mail. Overview of Database Mail Database Mail Profiles
Monitoring SQL Server 2008 R2 with Alerts and Notifications
Database Mail is an implementation of the standard SMTP protocol that enables database components to send emails.
A SQL Server Agent Operator is a person or group that can receive notifications from a job or an alert.
An Alert is a predefined response to an event.
@name=N'AdventureWorks2008R2 Transaction Log Full',
@alert_name= N'AdventureWorks2008R2 Transaction Log Full',
Estimated time: 45minutes
You have configured automated management tasks using SQL Server Agent and have configured security for those tasks. You now need to configure alerts and notifications for your Proseware system. The IT Support team at AdventureWorks has a defined escalation policy for SQL Server systems. As Proseware is part of the group of companies owned by AdventureWorks, you need to implement the relevant parts of this policy.
The IT Support team has supplied you with details from the policy that they have determined are needed for your Proseware server. For some automated tasks, notifications need to be sent every time the tasks are completed, whether or not the tasks work as expected. For other tasks, notifications only need to be sent if the tasks fail for some reason.
If you have enough time, you should also configure SQL Server to alert you if severe errors occur on the server.