Hi Friends,
I have created maintenance plan to rebuild index, check database integrity and cleanup history.but when i try to execute this plan it gives error
Please help me for this error which is given below:
Executed as user: SQDKKRO02\SYSTEM. ...n 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 08:57:37 Progress: 2008-09-18 08:57:42.38 Source: {6CC05EE3-5C89-4195-8AA6-C8CF69DB218D} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2008-09-18 09:20:08.29 Source: Rebuild Index Executing query "USE [OperationsManager] ".: 0% complete End Progress Progress: 2008-09-18 09:20:08.37 Source: Rebuild Index Executing query "ALTER INDEX [PK_AemAppBucketInfo] ON [dbo].[AemApp".: 0% complete End Progress Progress: 2008-09-18 09:20:08.37 Source: Rebuild Index Executing query "USE [OperationsManager] ".: 0% complete End Progress Progress: 2008-09-18 09:20:08.40 Source: Rebuild Index Executing query "ALTER INDEX [PK_AemCrashCounters] ON [dbo].[AemCra".: 0% complete End Progress Progress: 2008-09-18 09:20:08.40 ... The package execution fa... The step failed.
Thanks in advance,
Shikha