Saturday, April 13, 2013

SQL Server Agent(Agent XPs disabled)

If SQL Server Agent stopped with the following message in SSMS "SQL Server Agent (Agent XPs disabled)"

So here is the solution for this:

Run Following code

Step 1. 


EXEC SP_CONFIGURE 'Agent XPs'

Step 2.

EXEC SP_CONFIGURE 'show advanced options',1 

GO 

RECONFIGURE 
GO 

EXEC SP_CONFIGURE 'show advanced options'

Step 3.

EXEC SP_CONFIGURE 'Agent XPs',1 

GO 

RECONFIGURE


Now you are good to go.

Wednesday, April 3, 2013