SQL Server 2016 Email Issues
Recently had issues with Windows Updates causing a problem with a SQL Server 2016 installation in that it stopped SQL Server email from working. The solution to fix it is fairly easy….
However, if email is critical to your environment it may be worth checking with the Windows Server team when they will be deploying Windows updates so that you can check it doesn’t effect your systems. Particularly as we have seen this problem happening more than once on the same environment.
Any emails that SQL Server tries to send while this problem persists will not be lost, as they are just entered into the MSDB database and processed by the mail system. These will all be sent once email is back up and running.
To check for unsent emails…
SELECT * FROM msdb.dbo.sysmail_allitems WHERE sent_status='unsent'
If after a minute or so no email has been sent, try the following command