Help Center/ Relational Database Service/ User Guide/ Working with RDS for SQL Server/ Usage of Stored Procedures/ Cycling SQL Server Agent Error Logs
Updated on 2024-10-14 GMT+08:00
View PDF
Share

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. 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 RDS for 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