Notifylink jobs not running successfully, Enable OLE Automation and CMD shell
Posted by - NA - on 06 July 2009 01:29 PM

Database:

NOTE: Sites running NotifyLink (NLES) v4.5.0 or greater: This article applies only when the Disk Space Check job that is installed with the Messaging Component is enabled, and only when using SQL Server 2005.

Some jobs installed with NLES require OLE Automation and cmd shell to be enabled in order to work correctly. To enable these, log into the SQL Server Management Studio as the sa user and click the New Query button.  Copy and paste the following:

 

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Ole Automation Procedures', 1;

GO

RECONFIGURE;

GO

 

EXEC sp_configure 'show advanced options', 1

GO

RECONFIGURE

GO

 

EXEC sp_configure 'xp_cmdshell', 1

GO

RECONFIGURE

GO

Once copied, Click the Execute button.