Sql-server – How to checkdb automatically in AWS RDS

amazon-rdsawsdbcc-checkdbsql server

I'm pretty new to Amazon AWS and RDS. I have migrated my SQL Database to RDS and I have it up and running. I'm now looking to automate maintenance tasks. Anyone with experience with RDS can help me out how to configure automatic DBCC CHECKDB ? And also if its possible to configure some kind of notification in case it finds any data problem/corruptions? I know RDS has some limitations and not sure if this is possible.

As always any guidance and/or tips would be greatly appreciated.



Best Answer

If you refers to SQL Server, use the SQL Server Agent as you do usually.

Take a look here: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.Agent.html