[ACCEPTED]-How to check whether the job is disabled or Not in sqlserver management studio 2005?-sql-server-2005
Accepted answer
SELECT name, enabled, *
FROM msdb.dbo.sysjobs
WHERE enabled = 0
The above query will bring all disabled 2 jobs. What you are seeing is certainly strange 1 to me too.
Right-click on the jobs folder and select 2 Refresh to update the status icons and context 1 menu.
Source:
stackoverflow.com
More Related questions
Cookie Warning
We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.