{"id":385,"date":"2017-03-02T13:56:04","date_gmt":"2017-03-02T13:56:04","guid":{"rendered":"https:\/\/davidmichaelbrown.com\/?p=385"},"modified":"2017-03-02T20:47:45","modified_gmt":"2017-03-02T20:47:45","slug":"sql-2016-database-mail-not-working","status":"publish","type":"post","link":"https:\/\/davidmichaelbrown.com\/?p=385","title":{"rendered":"SQL 2016 configuring database mail on Windows 2016"},"content":{"rendered":"\n<!-- Facebook Like Button v1.9.6 BEGIN [http:\/\/blog.bottomlessinc.com] -->\n<iframe src=\"http:\/\/www.facebook.com\/plugins\/like.php?href=https%3A%2F%2Fdavidmichaelbrown.com%2F%3Fp%3D385&amp;layout=standard&amp;show_faces=false&amp;width=450&amp;action=like&amp;colorscheme=light\" scrolling=\"no\" frameborder=\"0\" allowTransparency=\"true\" style=\"border:none; overflow:hidden; width:450px; height: 30px; align: left; margin: 2px 0px 2px 0px\"><\/iframe>\n<!-- Facebook Like Button END -->\n<p>Recently I&#8217;ve started using SQL 2016 with basic availability groups for a new Citrix deployment. Whilst going through the configuration of my maintenance plans I thought it would be sensible to setup email notifications. I went through the following process of setting up database mail however I stumbled across an issue where the emails weren&#8217;t being sent.<\/p>\n<p id=\"xDhDAag\">To configure Database Mail open up the SQL management studio and right click Database Mail and select Configure Database Mail:<\/p>\n<p id=\"OVBiRKE\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-388 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8179f9ac53.png\" alt=\"Configure SQL Database Mail\" width=\"280\" height=\"230\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8179f9ac53.png 660w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8179f9ac53-300x246.png 300w\" sizes=\"auto, (max-width: 280px) 100vw, 280px\" \/><\/p>\n<p>We will follow through the wizard to complete the basic configuration:<\/p>\n<p id=\"yXZoprH\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-392 alignright\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8186be3db8.png\" alt=\"Start the Database Mail Configuration Wizard\" width=\"550\" height=\"414\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8186be3db8.png 1438w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8186be3db8-300x226.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8186be3db8-768x579.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8186be3db8-1024x772.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>Select set up Database Mail by performing the following tasks:<\/p>\n<p id=\"OruHNZG\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-393 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8188e7e515.png\" width=\"550\" height=\"413\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8188e7e515.png 1440w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8188e7e515-300x225.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8188e7e515-768x577.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8188e7e515-1024x769.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>If the Database Mail feature is not available you will be asked to enable the feature, select Yes:<\/p>\n<p id=\"zfkdWzp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-394 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b818ac3d23e.png\" width=\"550\" height=\"413\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b818ac3d23e.png 1440w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b818ac3d23e-300x225.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b818ac3d23e-768x577.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b818ac3d23e-1024x769.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>Create a new profile by populating the fields with meaningful information, then add an SMTP account:<\/p>\n<p id=\"kqvpAvO\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-395 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b819b5b0df3.png\" width=\"550\" height=\"414\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b819b5b0df3.png 1438w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b819b5b0df3-300x226.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b819b5b0df3-768x578.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b819b5b0df3-1024x770.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>Enter the relevant email settings for your server, this could be a local SMTP which allows relay, an Exchange server or even a Gmail account:<\/p>\n<p id=\"tmJtWVH\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-397 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81b8736acd.png\" width=\"550\" height=\"484\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81b8736acd.png 1158w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81b8736acd-300x264.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81b8736acd-768x675.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81b8736acd-1024x900.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>Select&nbsp;next:<\/p>\n<p id=\"xfWtMkd\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-398 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81bc99c38e.png\" width=\"550\" height=\"412\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81bc99c38e.png 1436w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81bc99c38e-300x225.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81bc99c38e-768x575.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81bc99c38e-1024x767.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>Select the public checkbox next to the profile you have created:<\/p>\n<p id=\"eRdSmAH\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-399 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81c35cdc00.png\" width=\"550\" height=\"414\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81c35cdc00.png 1436w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81c35cdc00-300x226.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81c35cdc00-768x578.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81c35cdc00-1024x770.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>Select next:<\/p>\n<p id=\"FrZRqDD\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-401 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81fd5329e4.png\" width=\"550\" height=\"413\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81fd5329e4.png 1434w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81fd5329e4-300x226.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81fd5329e4-768x577.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b81fd5329e4-1024x770.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>Select finish:<\/p>\n<p id=\"CvjShVZ\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-402 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82001e8591.png\" width=\"550\" height=\"412\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82001e8591.png 1438w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82001e8591-300x225.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82001e8591-768x576.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82001e8591-1024x768.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>If everything goes to plan you will have no errors on this next bit, you can then select close:<\/p>\n<p id=\"dKhhGVB\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-403 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8202829c67.png\" width=\"550\" height=\"416\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8202829c67.png 1432w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8202829c67-300x227.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8202829c67-768x580.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8202829c67-1024x774.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>Right click Database Mail and select send test e-mail:<\/p>\n<p id=\"uSSYjlJ\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-419 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b83912cf403.png\" alt=\"SQL send Test E-Mail...\" width=\"280\" height=\"228\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b83912cf403.png 630w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b83912cf403-300x244.png 300w\" sizes=\"auto, (max-width: 280px) 100vw, 280px\" \/><\/p>\n<p>Enter the email address you would like to send the test email to and select send test e-mail:<\/p>\n<p id=\"TCgwrEW\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-405 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b820d0bef7f.png\" width=\"350\" height=\"190\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b820d0bef7f.png 930w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b820d0bef7f-300x163.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b820d0bef7f-768x416.png 768w\" sizes=\"auto, (max-width: 350px) 100vw, 350px\" \/><\/p>\n<p>Wait a short while to see if you receive the message, I waited 60 seconds before I thought something wasn&#8217;t right:<\/p>\n<p id=\"zUsoROJ\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-406 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82111f3f96.png\" width=\"350\" height=\"247\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82111f3f96.png 786w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82111f3f96-300x211.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82111f3f96-768x541.png 768w\" sizes=\"auto, (max-width: 350px) 100vw, 350px\" \/><\/p>\n<p>After clicking OK nothing happened, my&nbsp;first line of troubleshooting was&nbsp;connecting to the Exchange server with Telnet. I was able to confirm I could send an email by entering in the commands manually. There were no logs under Database Mail on the SQL server, so I proceeded to check the Database Mail queues.<\/p>\n<p id=\"eQLQOVt\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-407 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8215c8b052.png\" width=\"550\" height=\"464\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8215c8b052.png 1452w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8215c8b052-300x253.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8215c8b052-768x648.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b8215c8b052-1024x865.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>Create a new query and enter the following for SQL&nbsp;2016:<\/p>\n<p><code>SELECT * FROM msdb..sysmail_event_log order by log_id DESC<br \/>\nSELECT * FROM msdb.dbo.sysmail_mailitems<br \/>\nSELECT * FROM msdb.dbo.sysmail_sentitems<br \/>\nUSE msdb<br \/>\nSELECT sent_status, *<br \/>\nFROM sysmail_allitems<br \/>\nSELECT is_broker_enabled FROM sys.databases WHERE name = 'msdb';<br \/>\nEXECUTE msdb.dbo.sysmail_help_status_sp<\/code><\/p>\n<p id=\"nifpnZw\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-409 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82219917f8.png\" width=\"550\" height=\"525\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82219917f8.png 1254w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82219917f8-300x286.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82219917f8-768x732.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82219917f8-1024x977.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>You can see that the sent_status of the mail is unsent.<\/p>\n<p>Open Windows Explorer and navigate to the following location:<\/p>\n<p id=\"dRTpFCY\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-413 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82572975b1.png\" width=\"550\" height=\"198\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82572975b1.png 1378w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82572975b1-300x108.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82572975b1-768x276.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82572975b1-1024x369.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>When double clicking on DatabaseMail.exe I received the following message stating the following feature couldn&#8217;t be installed. Clear there&nbsp;is a requirement for .NET Framework 3.5 (includes .NET 2.0 and 3.0):<\/p>\n<p id=\"BMMRSLS\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-414 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82592efa4e.png\" width=\"550\" height=\"400\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82592efa4e.png 1152w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82592efa4e-300x218.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82592efa4e-768x559.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b82592efa4e-1024x745.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>Open PowerShell, make sure you run it as administrator otherwise you will receive the following error:<\/p>\n<p id=\"gAWRcuT\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-415 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b826ffebab5.png\" width=\"550\" height=\"188\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b826ffebab5.png 1508w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b826ffebab5-300x103.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b826ffebab5-768x263.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b826ffebab5-1024x350.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>With Windows 2016 you will need to specify an additional source such as a DVD or ISO, enter the following command:<\/p>\n<p><code>DISM \/Online \/Enable-Feature \/FeatureName:NetFx3 \/All \/LimitAccess \/Source:D:\\sources\\sxs<\/code><\/p>\n<p>You will need to make sure you mount the ISO or insert the Windows 2016 DVD and select the correct path:<\/p>\n<p id=\"mxbwcul\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-416 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b828f82997e.png\" alt=\"DISM installation in progress\" width=\"550\" height=\"127\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b828f82997e.png 1508w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b828f82997e-300x69.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b828f82997e-768x177.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b828f82997e-1024x236.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>Installation completed:<\/p>\n<p id=\"HxxeqDx\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-418 aligncenter\" src=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b83417d1ca2.png\" alt=\"DISM installation completed\" width=\"550\" height=\"133\" srcset=\"https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b83417d1ca2.png 1508w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b83417d1ca2-300x72.png 300w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b83417d1ca2-768x185.png 768w, https:\/\/davidmichaelbrown.com\/wp-content\/uploads\/2017\/03\/img_58b83417d1ca2-1024x247.png 1024w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\n<p>If you attempt to open DatabaseMail.exe now it will send the items in the&nbsp;queue.<\/p>\n<p>I hope this helps and saves some head scratching!<\/p>\n\n<!-- Facebook Like Button v1.9.6 BEGIN [http:\/\/blog.bottomlessinc.com] -->\n<iframe src=\"http:\/\/www.facebook.com\/plugins\/like.php?href=https%3A%2F%2Fdavidmichaelbrown.com%2F%3Fp%3D385&amp;layout=standard&amp;show_faces=false&amp;width=450&amp;action=like&amp;colorscheme=light\" scrolling=\"no\" frameborder=\"0\" allowTransparency=\"true\" style=\"border:none; overflow:hidden; width:450px; height: 30px; align: left; margin: 2px 0px 2px 0px\"><\/iframe>\n<!-- Facebook Like Button END -->\n","protected":false},"excerpt":{"rendered":"<p>Recently I&#8217;ve started using SQL 2016 with basic availability groups for a new Citrix deployment. Whilst going through the configuration of my maintenance plans I thought it would be sensible to setup email notifications. I went through the following process of setting up database mail however I stumbled across an issue where the emails weren&#8217;t &#8230; <span class=\"more\"><a class=\"more-link\" href=\"https:\/\/davidmichaelbrown.com\/?p=385\">[Read more&#8230;]<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[26,9,99],"tags":[101,100],"class_list":["entry","post","publish","author-david-brown","post-385","format-standard","category-geeky-stuff","category-microsoft","category-sql","post_tag-database-mail","post_tag-sql-2016"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/davidmichaelbrown.com\/index.php?rest_route=\/wp\/v2\/posts\/385","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/davidmichaelbrown.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/davidmichaelbrown.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/davidmichaelbrown.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/davidmichaelbrown.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=385"}],"version-history":[{"count":11,"href":"https:\/\/davidmichaelbrown.com\/index.php?rest_route=\/wp\/v2\/posts\/385\/revisions"}],"predecessor-version":[{"id":423,"href":"https:\/\/davidmichaelbrown.com\/index.php?rest_route=\/wp\/v2\/posts\/385\/revisions\/423"}],"wp:attachment":[{"href":"https:\/\/davidmichaelbrown.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/davidmichaelbrown.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=385"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/davidmichaelbrown.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}