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

Maintenance Plan For Rebuild index Expand / Collapse
Author
Message
Posted Thursday, September 18, 2008 4:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 29, 2009 4:13 AM
Points: 10, Visits: 78
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
Post #571622
Posted Thursday, September 18, 2008 12:21 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 9, 2014 6:02 AM
Points: 2,674, Visits: 697
never use maint plans myself - always self code. Could be you've ticked the box which is/was fix problems if found - this always used to give problems in 7.0 and 2000. Split you steps out and run each manuallly to find the problem.

The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #572047
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse