SQL Server Performance Forum – Threads Archive

View jobs when SQL Server Agent is stopped

How can I view jobs in Management Studio when SQL Server Agent is stopped? Currently, it says SQL Server Agent (Agent XPs disabled). Is there a way to enable the XPs when the agent is stopped?

---

I don’t think there is any problem in viewing the jobs when sql agent is stopped. You can enable XPs through Surface Area Configuration…
OR
exec sp_configure ‘Agent XPs’, 1
go
reconfigure with override MohammedU.
Moderator
SQL-Server-Performance.com

---

]]>