This article is half-done without your Comment! *** Please share your thoughts via Comment ***
SQL Server Agent is a schedule of SQL Jobs which has a separate windows service for managing schedules.
If you are working with Enterprise level DB, you may find the hundreds or thousands of scheduled job in SQL Server Agent.
DBAs are also monitoring the SQL Job run history and all different status of SQL Jobs. In the background, you can access SQL Server Agent error logs which generate log files.
When we cycle the error logs, it is easier to open up a SQL Server Agent Error Log file when it is smaller in size.
We can reset log files so it starts fresh new log file which is small and you can easily troubleshoot it.
Check the below code for cycling the SQL Server Agent Error logs:
Note: SQL Server RESTART is not require
1 2 3 4 |
USE msdb go EXEC sp_cycle_agent_errorlog GO |
Leave a Reply