You are here:Home » SQL Server Problems » Agent XPs Disabled - SQL Server

Agent XPs Disabled - SQL Server

I notified so many times by the Object Explorer when I go to check the SQL Server Agent jobs. The notification is “Agent XPs disabled”.

SQLServerAgent-1

Then I need to run the following queries to enable SQL Server Agent XPs,
EXEC SP_CONFIGURE 'show advanced options',1
GO
RECONFIGURE
GO

EXEC SP_CONFIGURE 'Agent XPs',1
GO
RECONFIGURE
GO

EXEC SP_CONFIGURE 'show advanced options',0
GO
RECONFIGURE
GO
After running above script it will be enabled,

SQLServerAgent-2

I think you were getting this notification many times. So please share me your experience as “Why this SQL Agent XPs disabled sometime automatically after enabling it?”.