job calendar

• lof

  Default port

  Points: 1498

  More actions

  July 3, 2003 at 8:57 am

  #159740

  I am a visual person, and I'd like to be able to see all my scheduled jobs in one nice calendar-like view. Is there something out there that would do it? If not, I can write it, if someone can tell me where the job scheduling info is stored in SQL2k

  Thanks,

  Jakub

• Shas3

  Hall of Fame

  Points: 3671

  More actions

  July 3, 2003 at 9:02 am

  #464076

  Select name, enabled, Description, Date_created, Date_modified from msdb..sysjobs

  Shas3

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  July 3, 2003 at 10:12 am

  #464092

  Scheduling params are in sysjobschedules.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737530

  More actions

  July 3, 2003 at 10:20 am

  #464100

  sp_help_job is my favorite

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  http://www.dkranch.net