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.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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.
You have 2 choices:
Have an EC2 server with SQL Server installed to relay all email notification through Database Mail. Set up as a linked server and call a stored procedure to send the email via SQL Server's Database Mail.
Use the Cloud Alert or other 3rd party software for notification of failed jobs.