SQL Server Performance Forum – Threads Archive
View jobs when SQL Server Agent is stoppedHow 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…
exec sp_configure ‘Agent XPs’, 1
reconfigure with override MohammedU.