Agent XPs option is used to enable the SQL Server
Agent extended stored procedures on the server. When this option is not
enabled, the SQL Server Agent node is not available in SQL Server Management
Studio Object Explorer.
Note: SQL Server Management Studio Object Explorer does not
display the SQL Server Agent node unless these extended stored procedures are
enabled regardless of the SQL Server Agent service state. i.e Even if the SQL
Server Agent Service is Started or Stopped ,you will still see the SQL
Server Agent (Agent XPs disabled) in object explorer.
How do we get out of this SQL Server Agent (Agent XPs
disabled) problem?
Just run the below code.
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO
Once this is done, Refresh your Object Explorer or SQL Server
Agent node and its all done.
SQL Server Agent node is enabled for you.