motioneye
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Did applying one of the cumulative hotfixes after SP2 resolve this problem and if so, which one?