Skip to main content
SQL Planner

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. 1

    Open the script folder

    Navigate to C:\SQLMaintenancePlanner\Scripts\EmailProfileCreationCode\

  2. 2

    Open the T-SQL script

    Open SQL_Mail_Profile_Creation_T-SQLCode.sql.

  3. 3

    Edit SMTP details

    Update the script with your SMTP server address, user ID and password, and port number.

  4. 4

    Execute in SSMS

    Run the script in SQL Server Management Studio (SSMS).

  5. 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. 1

    Sign in

    Log in to the SQL Planner web application.

  2. 2

    Open Windows Server Monitoring settings

    Navigate to Settings → Win Server Monitoring tab.

  3. 3

    Enter escalation emails

    Locate the First Level Escalation email text box and enter recipient addresses (use a semicolon or comma as a separator).

Define the SMTP Database Mail settings the application should use:

  1. 1

    Open Email Server Setting

    Switch to the Email Server Setting tab.

  2. 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.