Post reply

SQL Agent Log files.

  • December 27, 2007 at 9:36 am

    #76858

    Is there a way to cycle the SQL Agent Error Logs like the SQL Server Error logs (i.e. exec sp_cycle_errorlog)?

  • December 31, 2007 at 10:47 am

    #763748

    Not that I know of. MS probably didn't think it would be useful to force SQL Server Agent to switch error logs since it archives and overwrites automatically.

    Greg

    Greg

  • January 1, 2008 at 9:01 pm

    #763903

    Stop and restart SQL Agent. Doesn't affect the database server and is very quick.

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

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