Agent XPs disabled

When you expand object explorer and see “Agent XPs Disabled” don’t worry. This happens when SQL Agent is stopped. I guess the idea is to reduce the surface area if SQL Agent isn’t running.

image

You don’t have to manually enable them. They will be enabled automatically when SQL Agent is started.

This was prompted by Paresh’s post http://paresh-sqldba.blogspot.com/2011/05/agent-xps-disabled-sql-server.html

Published 31 May 2011 16:11 by simonsabin
Filed under: ,

Comments

31 May 2011 16:39 by SimonS Blog on SQL Server Stuff

# Agent XPs disabled

When you expand object explorer and see “Agent XPs Disabled” don’t worry. This happens when SQL Agent