Recycle SQL Server Agent Error Logs

THIS TOPIC APPLIES TO: yesSQL ServeryesAzure SQL Database (Managed Instance only)noAzure SQL Data Warehouse noParallel Data Warehouse


On Azure SQL Database Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Database Managed Instance T-SQL differences from SQL Server for details.

Use this page to recycle the Microsoft SQL Server Agent Error Logs. Recycling the log closes the current SQL Server Agent error log and starts a new error log without restarting the SQL Server Agent service. Notice that SQL Server Agent maintains the nine most recent error logs. If there are already nine error logs present, recycling the error log causes SQL Server Agent to remove the oldest error log.

See Also

SQL Server Agent Error Log