October 29, 2003 at 6:14 am
Hi,
Does anyone know of a TSQL command simmilar to xp_readerrorlog that can read SQL Agent Error Logs ? ? ?
Or only EM can read this logs ?
October 29, 2003 at 7:04 am
xp_readerrorlog -1, 'p:\mssql\log\SQLAGENT.1'
October 29, 2003 at 7:08 am
Can this error logs be cycled like SQL Server Logs ? like sp_cycle_errorlog for SQL Error Logs.
October 29, 2003 at 7:28 am
No aware of it. SQL Server Agent will create new one once it is restarted.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply