Post reply

Daily maintenace plan results

  • January 19, 2011 at 4:01 am

    #230507

    Hi all, i am looking for help on how i can collect the results of all daily job runs from all my servers and output it into a table so i can then produce reports.

    I have around 50 servers all with daily maint plans on them whilst also jobs containing sp's.

    Any advice or pointers would be greatly appreciated.

    Thanks

  • January 19, 2011 at 8:29 am

    #1275340

    It's possible using Policy Based Management feature in SQL 2008.This article(http://www.mssqltips.com/tip.asp?tip=2192&home) will give you a scratch on the surface, you will have to dig more deeper to produce reports etc..

  • January 20, 2011 at 4:09 am

    #1275778

    Thanks for your reply Rohan i shall get right on to reading the link you posted.

    Thanks!

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

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