| How do we handle when SQL SERVER Agent is missing from SSMS?
This a happen some time that SQL Server Agent is missing from SSMS. And it is possible that SSMS will not shows the SQl Server Agent node or it will shows the agent node and this will not be further expanded. And this issue is very common issue at clients. And to solver this issue we use below code.
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO
Once we run the above code this will refresh our SSMS and will display in SQL Server Agent node in our SSMS. | | |