SQL Server 2005 Enterprise
I have a SQL Agent job that was created by a maintenance plan and runs weekly. The history for the job shows failure with the following message:
Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Error: 2013-10-27 02:15:24.64 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 Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:00:00 AM Finished: 2:15:24 AM Elapsed: 924.25 seconds. The package execution failed. The step failed.
However, if I go to the server and look at the log file for each execution of the job they show no errors and a success message. Anyone know how to correct this?