Link to home
Start Free TrialLog in
Avatar of motioneye
motioneyeFlag for Singapore

asked on

sql2005 maint plan return error

Hi,
I have a maint plan that always failed and return me an error below from the job output, do anyone know how do we get this resolved?
I'm running sql2005 with windows 2003 server and SP2

The job failed with following msg.

Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3033.00 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started:  3:12:21 AM
Error: 2008-02-04 03:36:46.21
   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.
End Error
Error: 2008-02-04 03:55:53.79
   Code: 0xC0024104
   Source: Rebuild Index Task
   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.
End Error
Error: 2008-02-04 04:09:45.09
   Code: 0xC0024104
   Source: Update Statistics Task
   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.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started:  3:12:21 AM
Finished: 4:09:46 AM
Elapsed:  3444.42 seconds


ASKER CERTIFIED SOLUTION
Avatar of maradam
maradam

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Did applying one of the cumulative hotfixes after SP2 resolve this problem and if so, which one?