Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2010-06-10 : 10:24:03
|
| Maintenanceplan on one of my Prodbox has failed with error asMessageExecuted as user: PRO\SQLService. ... 9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:00:04 AM Progress: 2010-06-10 01:00:11.73 Source: {ED0E3C0B-D86C-4FE7-8FE4-B3DA34F12F72} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2010-06-10 01:00:13.48 Source: Check Database Integrity Executing query "USE [MYDB] ".: 50% complete End Progress Progress: 2010-06-10 02:35:16.96 Source: Check Database Integrity Executing query "DBCC CHECKDB WITH NO_INFOMSGS ".: 100% complete End Progress Error: 2010-06-10 02:52:19.06 Code: 0xC0024104 Source: Update Statistics 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... The package execution fa... The step failed. |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-06-11 : 13:55:23
|
| View the history of the maintenance plan instead of the history for the job - this will give you the information on what task failed and why it failed.If you still have problems understanding why it failed, post that message here. |
 |
|
|
|
|
|
Maintenanceplan error