Post reply

Sql Job History

  • 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

  • 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

  • June 4, 2009 at 3:56 pm

    #1004945

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply