SQL Server 2008R2 Maintenance Plan Fails with: Execute method on the task returned error code 0x80004003 (Object reference not set to an instance of an object.). - by Hacky_J

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 679371 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 7/13/2011 11:24:50 PM
Access Restriction Public


Backup Maintenance Plan fails with: 
Date		7/13/2011 11:07:03 AM
Log		Job History (Backup Day 2.Full Backup Day 2)

Step ID		1
Server		Server\Instance
Job Name		Backup Day 2.Full Backup Day 2
Step Name		Full Backup Day 2
Duration		00:00:13
Sql Severity		0
Sql Message ID		0
Operator Emailed		
Operator Net sent		
Operator Paged		
Retries Attempted		0

Executed as user: Domain\User. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.1600.1 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  11:07:03 AM  Error: 2011-07-13 11:07:13.81     Code: 0xC0024104     Source: Execute SQL Server Agent Job Task      Description: The Execute method on the task returned error code 0x80004003 (Object reference not set to an instance of an object.). The Execute method must succeed, and indicate the result using an "out" parameter.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  11:07:03 AM  Finished: 11:07:14 AM  Elapsed:  11.016 seconds.  The package execution failed.  The step failed.
Sign in to post a comment.
Posted by Microsoft on 10/16/2011 at 4:27 AM

Greetings from the SQL Server Manageability team.

Thanks for writing in to Microsoft. We greatly value your feedback.

However, given the work that would be involved in implementing this work, and triaging against our current set of deliverables, we do not think, we would be able to get to this in the near future.

Having said that, we value your suggestions, and would like to assure you that, we would keep these ideas in mind, when we do revisit this feature in the future.

Thanks again for providing feedback and making SQL Server the greatest Database server.