Tuesday, September 23, 2014

0 Agent XPs disable !!

Somehow the SQL server agent show disable under SSMS.

image

Interestingly , the sqlagent is actually running . The actual root cause is somehow the ‘Agent XPs’ is disabled in the sp_configure.

EXEC SP_CONFIGURE 'Agent XPs'
go
EXEC xp_servicecontrol 'querystate','SQLAgent$SGC3SQL2K12'

image

The fix is simple, just enable it via sp_configure.

EXEC SP_CONFIGURE 'Agent XPs',1
go
reconfigure with override
go
select name,value,value_in_use,description from sys.configurations where name='Agent XPs'
image

image

The value should be changed automatically when start/restart sqlagent.

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates