Configuration
Configure Email Alert & Link it with SQL Planner
Configure SQL Server Database Mail, Windows Server monitoring recipients and link the email profile inside SQL Planner.
Updated
To ensure critical alerts reach the appropriate team members, follow these configuration steps for Database Mail and the SQL Planner application.
1. Configure SQL Server Database Mail
Before the application can send alerts, establish an SMTP profile within SQL Server:
- 1
Open the script folder
Navigate to C:\SQLMaintenancePlanner\Scripts\EmailProfileCreationCode\
- 2
Open the T-SQL script
Open SQL_Mail_Profile_Creation_T-SQLCode.sql.
- 3
Edit SMTP details
Update the script with your SMTP server address, user ID and password, and port number.
- 4
Execute in SSMS
Run the script in SQL Server Management Studio (SSMS).
- 5
Send a test email
Follow the instructions in the script to send a test email and verify SMTP settings.
2. Set up alert recipients (Windows Server Monitoring module)
- 1
Sign in
Log in to the SQL Planner web application.
- 2
Open Windows Server Monitoring settings
Navigate to Settings → Win Server Monitoring tab.
- 3
Enter escalation emails
Locate the First Level Escalation email text box and enter recipient addresses (use a semicolon or comma as a separator).
3. Link SQL Planner to the email profile
Define the SMTP Database Mail settings the application should use:
- 1
Open Email Server Setting
Switch to the Email Server Setting tab.
- 2
Configure connection details
Provide DB Server credentials, enter the exact DB Email Profile Name created in Step 1, and supply a Test Email recipient to send a final confirmation message.
