Post reply

Where is "Maintenance Plan "History" kept?

  • June 10, 2009 at 9:22 pm

    #205361

    My maintenance plan History* only shows two days of job runs. Is there are file\table contains the conplete list of these jobs? At the least, can I show more Maintenance Plan History details in Management Studio?

    TIA,

    Barkingdog

    * Sql 2008, Mangement Studio, Management, Maintenance Plans. Right click a Maintenance Plan, view History.

  • June 10, 2009 at 9:33 pm

    #1007764

    There are tables in msdb that hold some details, but most of the stuff that helps you debug or find issues will be in the logs, which are text files stored in /log if you enable logging.

    http://msdn.microsoft.com/en-us/library/ms190275.aspx

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

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