Ads

15 April 2015

SQL Server Agent - xp_readerlog[] returned error3 -System can not find the path specified

Here in the steps to follow:



USE MASTER
GO
EXEC msdb..sp_get_sqlagent_properties
GO

USE MASTER
GO
EXEC msdb.dbo.sp_set_sqlagent_properties
@errorlog_file=N'PATH'  -- N'k:\MSSQL10_50\MSSQL\Log\SQLAGENT.OUT'
GO


USE MASTER
GO
EXEC msdb..sp_get_sqlagent_properties
GO


Restart SQL server agent.

No comments:

Post a Comment