Sql Job History

• DanielP

  SSCrazy

  Points: 2320

  More actions

  June 4, 2009 at 1:43 pm

  #222043

  Where is the Frequency of when a job runs stored at? It is not in sysjobschedules table in msdb. I want a way to just purge out job history but weekly for daily run jobs, monthly for weekly run jobs, and yearly for monthly run jobs.

  Thanks,

  Daniel

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  June 4, 2009 at 3:01 pm

  #1004912

  Here are some scripts I use to show the jobs and thier related schedules. You should be able to use this to see how the tables are related.

  http://mssqltips.com/tip.asp?tip=1622

• DanielP

  SSCrazy

  Points: 2320

  More actions

  June 4, 2009 at 3:56 pm

  #1004945

  Thanks.