MaintenancePlan order

  • You should enable logging, that will help to determine what is wrong and give more information.

  • All good points, I couldn't put it any better than that.

  • My recommendation is to stop using maintenance plans altogether. They suck in a bunch of ways. Go to http://ola.hallengren.com/ and get his maintenance stuff and learn and use it. Incredibly powerful and useful stuff, for FREE, that even comes with super documentation. This is a serious no-brainer.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • When I run my maintance plan,get error message:The package execution failed. The step failed. How can I fix it.Thank you

  • Please post new questions in a new thread. Thank you.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Implement logging, read the logs. They will provide more information

  • I get this error when I view job history.What othet way to vie the error?

Viewing 7 posts - 16 through 21 (of 21 total)

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