December 27, 2007 at 9:36 am
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
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
Stop and restart SQL Agent. Doesn't affect the database server and is very quick.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy