June 10, 2010 at 8:44 am
Maintenanceplan on one of my Prodbox has failed with error as
Message
Executed 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.
June 10, 2010 at 9:15 am
Is that the message in the job history ? Are there error logs being written out ?
June 10, 2010 at 9:25 am
from jobhistory
June 10, 2010 at 11:45 am
homebrew01 (6/10/2010)
Is that the message in the job history ? Are there error logs being written out ?
June 11, 2010 at 12:11 pm
Check the history for the maintenance plan instead of the job history. This will show you which task failed, and on that task you can get the actual error message.
Post that error here and we can help you identify why the task failed.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply