Feature Request - Alerts through Database Mail
lewismoten
Posts: 58
SMTP mail is not an option for me at the moment with the current access control levels. However, one of the databases that I am monitoring has been granted access to send email to the relay. A database mail account has been setup and is used for SQL Agent alerts. It is also used with notifications on subtasks within maintenance plans. The repository does not sit on this same machine, so it does not have access to send out email.
It would be nice to have SQL Response send email alerts through database mail as an option.
In addition, my SMTP relay requires windows digest authentication. The current setup for repository emails does not have this feature. It just says account username/password (regular authentication measures).
It would be nice to have SQL Response send email alerts through database mail as an option.
In addition, my SMTP relay requires windows digest authentication. The current setup for repository emails does not have this feature. It just says account username/password (regular authentication measures).
execute msdb.dbo.sp_send_dbmail @profile_name = 'Database Monitoring', @recipients = [url='dba@yourdomain.com]'dba@yourdomain.com[/url]', @subject = 'Alert', @body='Hey, there is a problem!'
Comments
I've logged both your suggestions. I would expect that SMTP digest authentication will be included in a future point release.
Regards,
--
Daniel
You can't simulate SQL Response as the DB mail account?
unless they block by IP, SMTP authentication should work with a set of username/password, and a valid FROM email address
DBA, MCITP