Configure Database Mail

Home Up


 

Step 1, Invoke Database Mail (Configuration) Wizard

Step 2, Welcome to the Database Mail Wizard

Step 3, Select Configuration Task

Step 4, New Profile

Step 5, New Database Mail Account
(Add Button from previous Dialog)

Step 6, New Profile Completed

Step 7a, Manage Profile Security
(Public Profile)

Step 7b, Manage Profile Security
(Private Profile)

Step 8, Configure System Parameters

Step 9, Complete the Wizard

Step 10, Configuring...(Progress)

 

Step 11a, Add Service Account to Database Role in MSDB

Step 11b, Added Account to Database Role in MSDB

 

Step 12a, Configure Agent to Use Database Mail for Alerts

Step 12b, SQL Agent Properties
(BEFORE)

[Dang. I can't seem to find this screenshot.]

Step 12c, SQL Agent Properties
(AFTER)

Step 13, Restart SQL Agent Service