Skip to content

How to Resolve an Agent XPs Disabled Error

The following commands enable Agent XPs within SQL Server, in order to allow you to restart the SQL Agent service;

sp_configure 'show advanced options',1
go
reconfigure with override
go
sp_configure 'Agent XPs',1
go
reconfigure with override
go
sp_configure 'show advanced options',0
go
reconfigure with override
go

SHARE THIS POST: