RDS Sql Server Agent logs to Cloudwatch logs

Question

I've created RDS Sql Server Agent Scheduled Jobs with the role 'SQLAGENTUSERROLE' and configured RDS to publish agent logs to Cloud Watch Console but the Logs were not getting published in the console. Does It publish logs only for the user with sysadmin role?

Do I need anything else to be done for publishing agent logs to cloud watch?

Answer

SQLAGENTUSERROLE is not used to publish the logs to Cloudwatch it rather acts as an agent to manage certain administrative tasks, you can refer [Using SQL Server Agent](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.Agent.html) to understand what tasks are supported. Please note since RDS is a managed service it can restrict to perform certain administrative actions.

You can publish RDS MS SQL agent logs to Cloudwatch  which is achieved using a service linked IAM role, refer [Specifying the logs to publish to CloudWatch Logs](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Procedural.UploadtoCloudWatch.html#integrating_cloudwatchlogs.configure) and [Publishing SQL Server logs to Amazon CloudWatch Logs](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.SQLServer.html#USER_LogAccess.SQLServer.PublishtoCloudWatchLogs) for more information on it.

Hope it helps and if it does, I would appreciate if answer can be accepted so that community can benefit for clarity when searching for similar enquirers in Repost, thank you ;)

RDS Sql Server Agent logs to Cloudwatch logs

Relevanter Inhalt