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

 

ERROR MESAGGE:

“‘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. (Microsoft.SqlServer.Management.MaintenancePlanWizard)”

EXPLANATION:

You may experience this error when you want to do an operation that will use SQL Server Agent.

The reason is that “Agent XPs” is inactive as mentioned in the error message.

SOLUTION:

You can enable Agent XPs (Agent Extended Stored Procedures) in two ways.

First: Start SQL Server Agent. When you start the SQL Server Agent service, Agent XPs are automatically enabled.

Second: Using the T-SQL codes that I have given below.