SQL SERVER Agent Missing from SSMS

What I love the most about my job is the different experiences every time when I work with my client during Comprehensive Database Performance Health Check. Recently I had a very interesting experience where SQL SERVER Agent was Missing from SSMS.

SQL SERVER Agent Missing from SSMS MissingfromSSMS-800x287

It is totally possible that SSMS may not show the SQL Server Agent node or even if it shows the agent node, it will not further expand it. This is a very common issue I often see at my clients. The solution to this issue is very simple for agent Missing from SSMS.

sp_configure 'show advanced options', 1;  
GO  
RECONFIGURE;  
GO  
sp_configure 'Agent XPs', 1;  
GO  
RECONFIGURE  
GO  

Just run the code displayed here and refresh your SSMS (SQL Server Management Studio) and you will start seeing the SQL Server Agent node in your SSMS.

If you are interested in learning MongoDB,

Here are some of the relevant blog posts on MongoDB.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

, , , ,
Previous Post
Learning MongoDB is Easy
Next Post
Snowflake – Stored Procedure Template in JavaScript

Related Posts

Leave a Reply

Menu