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

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