SQL Send mail

First, enable the database Mail XPS feature.

To see if the Database Mail XPS feature is turned on, from the returned results, the value 0 description is not turned on, note that SQL Mail XPS is a Send mail feature that was provided by earlier versions of SQL Server, and now uses Database Mail XPS to implement sending mail.

Select Name,
Value
Description
Is_dynamic,
is_advanced
From Sys.configurations
Where name like '%mail% '

To start the database Mail XPS feature:

sp_configure ' show advanced options ', 1
Go
Reconfigure
Go

sp_configure ' Database Mail XPs ', 1
Go
Reconfigure
Go

After startup, the value of Database Mail XPS is 1

Ii. Configuring Database Mail

1. Open the Management directory, right-click Database Mail, and select the Configure Database Mail option:

2. Pop up the Database Mail Configuration Wizard and click Next:

3. Select the "Install Database Mail by performing the following tasks" option and click Next:

4, enter "Profile name", here I entered is: Db_mail, and then click on the right side of the "Add" button:

SQL Send mail