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 |
|
zhao
Starting Member
1 Post |
 Posted - 2009-10-16 : 03:03:03
|
| when I run maintainance plan , I got failed information as follows:Executed as user: fsl\b22551. 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: 10:02:27 AM Progress: 2009-10-16 10:03:17.30 Source: {5F050295-061F-45CA-8853-DA5B976439B2} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:02:27 AM Finished: 10:03:17 AM Elapsed: 50.172 seconds. The package execution failed. The step failed.Could u tell me what's meaning? |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-10-16 : 06:05:18
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=119596&whichpage=1 |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2009-10-17 : 10:16:46
|
| That output looks like it is coming from the SQL Server Agent Job. That is not going to tell you much - you need to look at the maintenance plan history instead. Open the Maintenance Plan folder, right-click on the maintenance plan and View History.From there, you can now find the plan that failed, the task in the plan that failed and better information on why that task failed. |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-10-22 : 10:43:22
|
| Check eventvwr logs, SQL logs, Maint plan view histoy, related job view history |
|
|
|
|
|
|
maintainance failed.