October 30, 2013 at 7:14 am
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?
October 30, 2013 at 7:17 am
October 30, 2013 at 7:32 am
It is set to "Quit the job reporting failure".
October 30, 2013 at 8:29 am
Since you are using maintenance plans make sure that the task that is failing has the FailParentOnFailure set to true. I believe that is it set to false by default.
October 30, 2013 at 8:49 am
Where would I find this?
October 30, 2013 at 9:07 am
Right click the maintenance plan and select modify. Then find the task that is failing and edit the properties. It should be one of the properties.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply