Help Center> Relational Database Service> User Guide> Working with RDS for SQL Server> Usage of Stored Procedures> Cycling SQL Server Agent Error Logs
Cycling SQL Server Agent Error Logs
Scenarios
You can use a stored procedure to close the current SQL Server Agent error log file and cycle the SQL Server Agent error log extension numbers (just like a server restart). The new SQL Server Agent error log contains a line indicating that the new log has been created.
Prerequisites
An RDS Microsoft SQL Server DB instance has been connected. Connect to the DB instance through the Microsoft SQL Server client. For details, see Connecting to a DB Instance Through a Public Network.
Procedure
Run the following command to cycle the SQL Server Agent error log:
EXEC [msdb].[dbo].[rds_cycle_agent_errorlog]
After the command is executed, the system displays the following information.
HW_RDS_Process_Successful_Completed
Parent topic: Usage of Stored Procedures
Last Article: Updating Database Statistics
Next Article: Cycling SQL Server Error Logs
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.