How to enable Agent XPs?:
When you restart SQL services, sometimes SQLServer Agent will not expand in SSMS, run following query to put the Agent back to online.
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'AGENT XPs', 1;
GO
RECONFIGURE;
GO
No comments:
Post a Comment