update statistics failing intermittently in SQL Server 2005


  • We have a job that runs nightly to updates statistics. It takes about 1.5 hrs to run on a 30GB db. It is failing about every 3 or 4 days with the following error message in job history:



    Executed as user: CH\sqlbackup. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.4035.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  12:00:00 AM  Progress: 2011-04-06 00:00:02.15     Source: {1214E6AF-3610-46FB-8F10-F4A88F29AD42}      Executing query "DECLARE @Guid UNIQUEIDENTIFIER      EXECUTE msdb..sp".: 100% complete  End Progress  Error: 2011-04-06 01:15:01.18     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:  12:00:00 AM  Finished: 1:15:01 AM  Elapsed:  4500.77 seconds.  The package execution failed.  The step failed.

    PatM Reno
    6 เมษายน 2554 16:50