Brad’s Sure Guide to SQL Server Maintenance Plans- P9: SQL Server has a reputation as being a simple database application to install, configure, and maintain. This is a little misleading. SQL Server is a powerful relational database that can handle the needs of the largest organizations and, as such, its proper maintenance almost certainly requires the attention of an experienced DBA. | Chapter 2 Before you Create any Maintenance Plans. Figure If all went well you will see lots of Success entries. If the Configuring. screen reports success then Database Mail has been successfully set up for your SQL Server instance - or has it While the success statuses are great we still don t know if Database Mail has really been set up correctly. For example perhaps there was a typo in the e-mail address or password made when entering the SMTP information. If there was Database Mail won t have any way of knowing this. In short this means that you need to test your set up. In order to test that Database Mail really is working as expected close the Configuring. screen then right-click on the Database Mail folder just as you did when you began the Database Mail Wizard and select Send Test E-Mail as shown in Figure . 41 Chapter 2 Before you Create any Maintenance Plans. B J Management a p olicy Management E E3 Data Collection ffl 3 Resource Governor Maintenance Plans S LJ SQL Server Logs 3 Distribute Lj Legacy SQL Server A Configure Database Mail Send Test E-Mail. View Database Mail Log Reports Refresh Figure To ensure that Database Mail really works you need to send a test e-mail. The Send Test E-Mail screen shown in Figure will appear. Figure You need to enter your e-mail address to see if a test e-mail can be sent successfully from Database Mail. Notice that the first option is Database Mail Profile and it has a drop-down box next to it. This is used to select the profile you want use to send the test e-mail. In this case you need to use the profile you just created which was Maintenance Plan. If the profile you want to test is not selected then you can choose it by selecting it from the drop-down box. 42 Chapter 2 Before you Create any Maintenance Plans. Fill in the To box with your e-mail address and click on Send Test E-Mail this box will be grayed out until you enter an e-mail address . The screen shown in Figure should appear. .
