Post reply

Change the location of Maintenance Plan Logs

  • March 5, 2009 at 2:27 am

    #206648

    Hello,

    Is it possible to change/specify the location of the logs created by SQL 2005 maintenance jobs? I dont seem to be able to find a way of doing it, have tried google and BOL.

    Regards,

    D.

  • March 5, 2009 at 3:23 am

    #953874

    Hello Duran,

    Yes it's quite possible....

    Modify the Maintenance plan... in the design right pan top tool bar click 'Reporting and logging' (beside Manage Connections) and specify the path in 'Reporting'.

    HTH

    Cheers!!!

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • March 5, 2009 at 3:55 am

    #953889

    Thank you very much, most appreciated.

    Regards,

    D.

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

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