SQL 2008 R2: Agent XPS component is turned off as part of the security configuration of this server.

By coreboarder in Backup, Disaster Recovery, SQL

To correct this
Open a new query and paste the following:

In the query window type the following:

sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘Agent XPs’, 1;
GO
RECONFIGURE
GO

After you run it you should expect to see the following in the message window.

Configuration option ‘show advanced options’ changed from 0 to 1. Run the RECONFIGURE statement to install.
Configuration option ‘Agent XPs’ changed from 0 to 1. Run the RECONFIGURE statement to install.

If you want to disable either just replace the 1 with a 0.