Post reply

maintenance plan history not being kept. Is there something besides cleanup history maintenance plan that could be doing this?

  • February 18, 2014 at 7:26 am

    #1689896

    In sqlagent properties there is a history tab, if the log history size is too small and you have a lot of jobs, history will be truncated sooner than you individual job settings suggest.

    ---------------------------------------------------------------------

  • February 18, 2014 at 7:33 am

    #1689898

    Thanks very much for the information, George. That could be the issue, since it was only set to 1000 rows in properties.

    I just increased it to 500000, and will see tomorrow if more than 2 days' history is showing up, and will mark your reply as the answer if it works.

  • February 18, 2014 at 7:36 am

    #1689900

    500000 could be a bit over the top, it has an effect on msdb size.

    ---------------------------------------------------------------------

  • February 18, 2014 at 7:53 am

    #1689915

    Thanks, George.

    I'll monitor the size of msdb, and see how it's growing, and see how much space it will be with 10 days' history, and reduce the number of days if it's too much.

  • February 19, 2014 at 5:56 am

    #1690216

    Thanks very much, George. It worked.

  • February 19, 2014 at 6:23 am

    #1690232

    good stuff.

    ---------------------------------------------------------------------

Viewing 6 posts - 1 through 7 (of 7 total)

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