"'Agent XPs' Component Is Turned Off as Part of the Security Configuration for This Server." Error While Creating Maintenance Plans on MsSQL Server 2005
While trying to create some maintenance plans on MsSql server 2005 (default installation) with SP2 installed I have received this error message:
'Agent XPs' component is turned off as part of the security configuration for this server.
While trying different solutions from Microsoft, MSDN and different forums I have found one that worked for me. Open new query window, copy code below and hit F5 for executing. After this you can create plans.
1 2 3 4 5 6 7 8