Configure Email Alerts

The process of setting up SQL Server to send emails is a tad bit arduous. Set up your server by following these directions step by step.

Step 1. Configure Database Mail

Configure Database Mail - SQL Serverdocsmsft

Step 2. Configure Security

Configure SQL Server Agent Mail to Use Database Mail - SQL Serverdocsmsft

Step 3. Create a Database Mail Account

This is where you'll need SMTP server configuration information like server name and port.

Create a Database Mail Account - SQL Serverdocsmsft

Step 4. Create a Database Mail Profile

Name your mail profile Monitoring. The framework depends on this.

Create a Database Mail Profile - SQL Serverdocsmsft

Step 5. Set Up An Operator

Operators are usually distribution list that get notified when things go south.

Operators - SQL Server Agentdocsmsft