When converting one of native SQL maintenance plans over to a LiteSpeed maintenance plan, one step of the plan is running the "Update Statistics" task for all tables in a specific database. The task works in the native SQL maintenance plan but it fails when it is run in a LiteSpeed maintenance plan.on Windows Clusters x64 for SQL 2005
Example of the error being displayed in the management console when the step tries to execute:
Executed as user: [domain][svc_account]. ...00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:37:39 PM Progress: 2009-01-17 13:37:40.78 Source: {8F462E60-90AD-4A43-990F-073DCC14E64F} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2009-01-17 13:38:12.56 Source: Update [dbname] Statistics Executing query "use [b4wv] ".: 0% complete End Progress Progress: 2009-01-17 13:38:12.59 Source: Update [dbname] Statistics Executing query "UPDATE STATISTICS [dbo].[tablename] WITH S".: 0% complete End Progress Progress: 2009-01-17 13:38:12.59 Source: Update Statistics Executing query "use [b4wv] ".: 0% complete End Progress Progress: 2009-01-17 13:38:12.59 Source: Update [dbname] Statistics Executing query "UPDATE STATISTICS [dbo].[tablename".: 1% complete End Progress Progress: 2009-01-17 ... The package execution fa... The step failed.
None.
STATUS:
Waiting for fix in a future release of LiteSpeed.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center