Subscribe | Alerts via Email
View All Quotes
“Just because nobody complains doesn't mean all parachutes are perfect.”
-Benny Hill
<July 2010>
SunMonTueWedThuFriSat
27282930123
45678910
11121314151617
18192021222324
25262728293031
1234567
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

©2010 Cal Zant
Sign In
Total Posts: 106
This Year: 5
This Month: 1
This Week: 0
Comments: 2

On SQL Server 2008, when I went to create my first Maintenance Plan I got an error message that said:

'Agent XPs' component is turned off as part of the security configuration for this server.  A system administrator can enable the use of 'Agent XPs' by using sp_configure.  For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online.

'Agent XPs component is turned off as part of the security configuration for this server

To turn them on, all you have to do is run this script:

USE master
GO
sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
sp_configure 'Agent XPs', 1
GO
RECONFIGURE
GO

After running the script you should see messages like the ones shown below:

T-SQL to enable Agent XPs using sp_configure

Friday, April 17, 2009 3:26:49 PM (Central Standard Time, UTC-06:00)  #