table to view whether particular job schedule is enabled or not

• Joseph-465703

  SSCrazy

  Points: 2122

  More actions

  November 13, 2008 at 11:23 am

  #215175

  Hi,

  can you guys tell me which is the table to view whether particular job schedule is enabled or not in sql 2005.

  Thanks

  Joseph

• winash

  SSChampion

  Points: 11446

  More actions

  November 13, 2008 at 1:09 pm

  #898277

  The sysschedules table in the msdb database has a column "enabled" which will let you know if a job schedule is enabled or not...

  However - the recommended way is to use the sp_help_job system stored procedure instead of directly querying the system tables...