Cycling SQL Server Agent Error Logs

Scenarios

You can use a stored procedure to close the current RDS for SQL Server Agent error log file and cycle the Agent error log extension numbers (just like a server restart). The new Agent error log contains a line indicating that the new log has been created.

Prerequisites

An RDS for SQL Server DB instance has been connected. You can connect to the DB instance through a SQL Server client. For details, see Connecting to a DB Instance Through a Public Network.

Procedure

Run the following command to cycle the RDS for SQL Server Agent error log:

EXEC [msdb].[dbo].[rds_cycle_agent_errorlog]