Since Database Mail is not supported on Amazon RDS with SQL Server, can anyone offer any suggestions on how to send e-mail notifications for failed SQL Server jobs in Amazon RDS?
Thanks in advance for any suggestions or workarounds.
Sql-server – Database Mail on Amazon RDS / SQL Server
amazon-rdsdatabase-mailsql server
Related Question
- Sql-server – Database Mail sending functionality not working on local system
- Sql-server – Use SQL Server Database Mail with Amazon SNS
- Sql-server – Require to Send a formatted HTML Email via Database Mail in Sql Server 2008 R2
- Sql-server – Can send test database mail but job emails failing
- Sql-server – UPDATE STATISTICS options fail in Amazon RDS SQL Server
Best Answer
AWS has posted a detailed blog post based on the way that UnderArmor solves this limitation. It involves a linked SQL Server that you run in EC2 and that EC2 instance is configured to SES to relay the messages through.
AWS RDS Database Mail