Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Agent Error Log Files

Author  Topic 

cjeremy74
Starting Member

2 Posts

Posted - 2007-12-28 : 10:08:57
Is there a straightforward method to cycle SQL Agent error logs in SQL 2000 like there is in SQL 2005 (sp_cycle_agent_errorlog).

I know that I can restart the agent to do this - but I would rather just schedule a job to take care of this and cycle SQL error logs as well. I am open to other suggestions/best practices.

Thanks - J

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-28 : 23:56:43
No.
Go to Top of Page
   

- Advertisement -