Index Maintenance plan succeeded but SQL Agent job history shows fail..

• SQlLogic

  SSCrazy Eights

  Points: 9685

  More actions

  July 28, 2012 at 5:22 pm

  #259930

  HI guys,

  i am working with weird situation.

  I did setup Maintenance plan for Index Reorganize and Statistics Update. After job finished in SQL agent job it shows fail but Maintenance plan History shows succeeded .Below is error detail from SQL agent.

  Error: Code: 0xC0024104 Source: Reorganize Index Description: The Execute method on the task returned error code 0x80131501 (An exception occurred while executing a Transact-SQL statement or batch.). The Execute method must succeed, and indicate the result using an "out" parameter.

  Any idea what are the steps to be taken to solve this?

  Thank you...

• mikehillwig

  SSC Enthusiast

  Points: 123

  More actions

  July 29, 2012 at 2:16 pm

  #1518962

  While it won't fix your immediate problem, I'd ask why you're using a maintenance plan to maintain indexes and statistics.

  Maintenance plans do a brute force reorganization or rebuild. That means your server is doing MUCH more work than needed.

  There are some really good scripts here that put some logic behind rebuilding indexes. You might be better served to use one of those.