Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Failure message for successful SQL Agent job ? Expand / Collapse
Author
Message
Posted Wednesday, October 30, 2013 7:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, March 07, 2014 7:44 AM
Points: 47, Visits: 235
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?
Post #1509753
Posted Wednesday, October 30, 2013 7:17 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:12 AM
Points: 532, Visits: 787
Verify that the "On Failure" action for the job step that is failing is set to "Quit the job reporting failure".



Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1509755
Posted Wednesday, October 30, 2013 7:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, March 07, 2014 7:44 AM
Points: 47, Visits: 235
It is set to "Quit the job reporting failure".
Post #1509769
Posted Wednesday, October 30, 2013 8:29 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:12 AM
Points: 532, Visits: 787
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.



Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1509806
Posted Wednesday, October 30, 2013 8:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, March 07, 2014 7:44 AM
Points: 47, Visits: 235
Where would I find this?
Post #1509820
Posted Wednesday, October 30, 2013 9:07 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:12 AM
Points: 532, Visits: 787
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.



Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1509827
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse