Post reply

Job history not showing up under Maintenace plan

  • August 11, 2006 at 2:08 pm

    #114512

    I have created a Maintenance plan through Enterprise manager and when a backup or Transaction backup completes I cant view any of the history. I have confirmed that the jobs scheduled to run complete Successfully. Where in the plan do I configure the history of the job?

     

  • August 11, 2006 at 3:07 pm

    #654677

    Right Click Maintenance plan in Enterprise manager

    MP History is 9th step in wizard, one after Report generate.

    Select  Write history  to MSDB.dbo.sysdbmaintplan-history table

    Select 1000 or whatever # or rows for this table.

     

     

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • August 14, 2006 at 8:39 am

    #654881

    Thanks

    -Rayguy

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

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