Enabling Agent XPs on a new SQL Server 2005 install

I had to do this prior to creating a maintainence plan for a database on my development 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.

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO

Author Dave Howard

I have been involved in IT development for the last 10 years - a lot of it around desktop applications and telecoms.

Comments

Thanks

04/Jun/2010 07:37 AM

Thanks Dave It worked... Thanks for your help

20/Jan/2011 19:11 PM