Add support for Agent Operators and email notifications in RDS for SQL Server.

Question

RDS for SQL Server currently supports SQL Server Agent jobs but not operators/notifications.

The current suggested workaround by AWS is to export the instance error log to CloudWatch and to create a log group metric filter + alarm + SNS topic/subscription which is cumbersome and also does not include the job name/details.

I wish AWS would add support to those basic features we had since SQL Server 2000 so we could easily define and enjoy them.

Answer

Hello,

Warm Greetings.

I understand that RDS for SQL Server supports SQL Server Agent jobs but lacks support for operators/notifications. The suggested workaround by AWS is exporting the instance error log to CloudWatch and creating a log group metric filter + alarm + SNS topic/subscription, which is cumbersome and lacks job name/details. Hence, you would like to get this feature added to RDS service.

To begin with, please note that as mentioned by the AWS team currently this feature is not available in RDS service. Which is clearly mentioned with statements  “Email notifications through SQL Server Agent aren't available from a DB instance. SQL Server Agent alerts and operators aren't supported” in the below documentation.

[+] Using SQL Server Agent - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.Agent.html

Please look into below documentation for the possible workaround which might be suitable for your use case.

[+] https://repost.aws/knowledge-center/rds-sql-server-sns-notification-events

Add support for Agent Operators and email notifications in RDS for SQL Server.

Relevant content