Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Enabling Agent XPs on a new SQL Server 2005 install

Created: 04 Mar 2009
Antonp's picture
+5 5 Votes
Login to vote

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