enabled/disbaled job:MS sql server 2005

• litu deb

  SSC Eights!

  Points: 818

  More actions

  December 7, 2007 at 12:29 am

  #184682

  Hi All,

  If any sql job was enabled yesterday.how to be confirmed that the job was really enabled yesteday.

  Thnks,

  Litu

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  December 7, 2007 at 4:15 am

  #758006

  Check in sysjobschedules & sysschedules tables in msdb database.

  --Ramesh
  

  ---

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  December 7, 2007 at 8:32 am

  #758114

  SSMS also shows this.