October 27, 2008 at 12:01 pm
I have a maintenance plan reindex all user db every week. But the job failed and give the following error messages:
Executed as user: IGTMASTER\SQL2005. ... 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:00:01 AM Progress: 2008-10-26 05:00:05.55 Source: {89ED5141-0B0E-4964-B23A-CB28964EBA68} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2008-10-26 05:04:12.07 Source: Rebuild Index Task Executing query "USE [xDDI] ".: 0% complete End Progress Progress: 2008-10-26 05:04:12.11 Source: Rebuild Index Task Executing query "ALTER INDEX [PK___2__16] ON [dbo].[DP_Access_Point".: 0% complete End Progress Progress: 2008-10-26 05:04:12.11 Source: Rebuild Index Task Executing query "USE [xDDI] ".: 0% complete End Progress Progress: 2008-10-26 05:04:12.11 Source: Rebuild Index Task Executing query "ALTER INDEX [AK_DP_ALE_Posting_Archive] ON [dbo].[".: 0% complete End Progress Progress: 2008-10-26 05:04:12.11 ... The package execution fa... The step failed.
Can anyone tell me what happened?
Thanks
October 27, 2008 at 12:15 pm
I had similar happen, to debug I usually go to the maintenance plan and get the script of the job that runs, and run it manually in Management Studio. It has always given me more information when it fails this way.
October 27, 2008 at 12:16 pm
i did it ..it works fine on management studio...but the job failed.
October 27, 2008 at 1:02 pm
October 27, 2008 at 1:16 pm
? Edition and version of your sqlserver please.
- chances of locking or deadlocking ?
- online or offline rebuild ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply