title: How to check whether the job is disabled or Not in sqlserver management studio 2005?
body: <p>As part of the holiday processing some of the jobs are disabled in sql server using script.
  <br><br>
  They are not disabled manually.<br><br>
  Now when we see the jobs there is a check mark for enable entity.<br><br>
  And when we right click on the job the instead of enable thing being highlighted disable entity is highlighted.<br><br>
  Now we are getting doubt whether jobs are disabled or not.<br><br>
  How to check it through a query is there any status bit which tells us state of the job.<br><br>
  Whether it is disabled or enabled.<br><br>
  Please suggest/advise.</p>