How to check if a job is disabled or not in sqlserver 2005 management studio?

Question

As part of the holiday processing, some of the tasks are disabled on the sql server using a script.

They are not disabled manually.

Now, when we see the tasks, there is a flag for the enable object.

And when we right-click on the task, it is highlighted instead of turning on the object selected to turn off the object.

Now we doubt that the work is disabled or not. How to check this on request, is there a status bit that tells us about the status of the job.

Regardless of whether it is disabled or enabled. Please suggest / advise.

Answer 1

SELECT name, enabled, * 
FROM msdb.dbo.sysjobs
WHERE enabled = 0

The above query will bring all disabled jobs. What you see is strange to me too.

Answer 2

Right-click the job folder and select Refresh to refresh the status icons and context menu.