Enabling Agent XPs on a new SQL Server 2005 install
Created: 04 Mar 2009
I had to do this prior to creating a maintainence plan for a database on my Production box.
When I first tried to create the plan I was given a message that "Agent XPs" are not enabled and that I should run sp_reconfigure.
Run this statement then you can do get on with it:
SQL Query: sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Agent XPs', 1; GO RECONFIGURE GO
The Endpoint Management Community Blog is the perfect place to share short, timely insights including product tips, news and other information relevant to the Endpoint Management community. Any authenticated Connect member can contribute to this blog.