Post reply

sqlagent job hystory not showing in sqlserver 2014

  • February 24, 2017 at 2:00 am

    #321978

    Hi,

    In one of my prodcution sql server 2014 server   i have Log shipping jobs running  along other jobs also scheduled

    when i go to check particular job history it shows only one day old but i want to maintain all the jobs history at least 15-30 days for each job
    how much values need to change in agent job properties history?

    Thanks in advance
    Please suggest solution

    I

  • February 24, 2017 at 2:12 am

    #1930096

    Tick Remove agent history and set to to Older than: 1 Month(s).  Then either untick Limit size of job history log, or make sure than the numbers of rows per job is high enough for the frequency of your most frequent job, and that the overall job history log size is high enough to hold the history for all of your jobs for the desire time period.

    John

  • February 24, 2017 at 2:21 am

    #1930099

    Hi Thanks for reply,

    currently i have changed the default 1000 & 100 to below

    15000 & 15000 but still hystory of each job shows one day old
    Please suggest

    Thanks in advance

  • February 24, 2017 at 2:27 am

    #1930102

    Now you just have to sit and wait.  If that job history wasn't there before, it won't be now, just because you've changed the number of rows to retain.  If you've chosen your numbers of rows correctly (and I've a feeling you're just guessing, since you've set the overall number the same as the per-job number) then after 15-30 days, you should be able to see all the job history you want.

    John

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

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