August 1, 2018 by Kenneth Fisher
Why database mail? Well, since last month’s homework was setting up a SQL Agent job, it would be nice to have an easy way to send messages about a jobs progress, success, or even failure. I’ve even used DBMail to send out an automated status message. I generated an HTML report and sent it via DB Mail.
The goal in the end, is to successfully send yourself a test email. Pass/Fail
Now, this does require you have an email server you can use, but from what I’ve been told you can use https://smtp.live.com/. You have to create a free account, but hey, free :).