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