Saturday, 5 July 2014

SQL Agent Component Turned off Error.




When ever we try to create the maintenance plan /start the Sql Agent we were getting the below error.





Or
 

To solve this error we need to enable the Agent XP’s with SP_Configure procedure.
Here is the syntax for the same..

     GO

     sp_configure 'Agent XPs', 1;

     GO

     RECONFIGURE

     GO

No comments:

Post a Comment