SQL Server: Agent XPs Disabled

Recently, on SQL Server where our SSIS jobs were deployed, while trying to expand SQL Server Agent node, we faced error "Agent XPs Disabled" as shown below: To fix this issue, we executed below queries in the sequence: EXEC SP_CONFIGURE 'show advanced options', 1GO RECONFIGURE GO EXEC SP_CONFIGURE ' show advanced options' EXEC SP_CONFIGURE 'Agent … Continue reading SQL Server: Agent XPs Disabled

Advertisements