Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cmccannm
Starting Member
5 Posts |
 Posted - 2008-11-07 : 17:18:21
|
| Hello,I have a Maintenance Plan job that takes log backups of the User databases. Most of the time it runs successfully. Every now and then, it sends out a failure notification, however the log for the job shows success for the two tasks and the job has created all the log backup files. This is the message in the job step history:End Progress Error: 2008-07-26 12:15:41.04 Code: 0xC0024104 Source: Reporting Task for subplan-{08F57368-7039-4250-9BA3-AB97CEE97007} Description: The Execute method on the task returned error code 0x80131931 (Data is Null. This method or property cannot be called on Null values.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Error: 2008-07-26 12:15:41.04 Code: 0xC0024104 Source: Reporting Task for subplan-{0921A72F-E46C-4023-847C-B30E1D8382EA} Description: The Execute method on the task returned error code 0x80131931 (Data is Null. This method or property ca... The package execution fa... The step failed.I am running SQL Server 2005 Standard Edition SP2 CU6 (version 9.0.3228) on a 32-bit Windows Server 2003 Standard Edition SP2. The Log Backup Subplan only has 2 tasks: Maintenance Cleanup Task and Back Up Database Task.Have any of you experienced this before? I don't want the job to send out failure notifications to the support team when it is successfully completing the tasks. What should I do to correct this? |
|
|
|
|
|
Log Backup Jobs Failing-Log Files Are Created