Client Management Suite

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