Agent Error Log?

  • How can I clear the SQL server agent error log?

  • While SQL Server Agent is stopped, delete the file. When you start up SQL Agent again, it will create a new blank file. By default it should be called SQLAGENT.OUT and located in the log folder.  If you are not sure where it is, right click on SQL Server Agent and select Properties. The Error Log setting is near the bottom of the General tab.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply