one maintenance job (rebuild index task on user databases) is failing with event 12291. all other maintenance jobs like backup are working fine. the sql server agents runs under a domain admin account. the problem is not related to a specific database. it crashes on any db chosen. we have deleted and recreated to maintenance plan and it still doesn't work the job history: ep ID 1 Server STZ-SQL1 Job Name MaintenancePlan.weekly_reb_indexes Step Name weekly_reb_indexes Duration 00:27:43 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Executed as user: IBA\iba_admin. ...sion 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 00:25:00 Progress: 2012-07-22 00:25:01.17 Source: {B00EA0E0-FFD0-48C4-B704-8CAE5645858D} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2012-07-22 00:29:21.35 Source: Rebuild Index Task Executing query "USE [adalib] ".: 0% complete End Progress Progress: 2012-07-22 00:29:22.03 Source: Rebuild Index Task Executing query "ALTER INDEX [A10_ALT_1] ON [dbo].[A10] REBUILD PAR...".: 0% complete End Progress Progress: 2012-07-22 00:29:22.03 Source: Rebuild Index Task Executing query "USE [adalib] ".: 0% complete End Progress Progress: 2012-07-22 00:29:24.01 Source: Rebuild Index Task Executing query "ALTER INDEX [A10_ALT_2] ON [dbo].[A10] REBUILD PAR...".: 0% complete End Progress Progress: 2012-07-22 00:29:24.01 Source: Rebuild Index Task Executing query "USE [adalib] ".: 0% complete End Progress Progress: 2012-07-22 00:29:25.02 Source: Rebuild Index Task Executing query "ALTER INDEX [A10_ALT_3] ON [dbo].[A10] REBUILD PAR...".: 1% complete End Progress Progress: 2012-07-22 00:29:25.02 Source: Rebuild Index Task Executing query "USE [adalib] ".: 1% complete End Progress Progress: 2012-07-22 00:29:26.56 Source: Rebuild Index Task Executing query "ALTER INDEX [A10_ALT_4] ON [dbo].[A10] REBUILD PAR...".: 1% complete End Progress Progress: 2012-07-22 00:29:26.56 Source: Rebuild Index Task Executing query "USE [adalib] ".: 1% complete End Progress Progress: 2012-07-22 00:29:28.23 Source: Rebuild Index Task Executing query "ALTER INDEX [A10_ALT_5] ON [dbo].[A10] REBUILD PAR...".: 1% complete End Progress Progress: 2012-07-22 00:29:28.23 Source: Rebuild Index Task Executing query "USE [adalib] ".: 1% complete End Progress Progress: 2012-07-22 00:29:29.22 Source: Rebuild Index Task Executing query "ALTER INDEX [A10_F_ID] ON [dbo].[A10] REBUILD PART...".: 2% complete End Progress Progress: 2012-07-22 00:29:29.22 Source: Rebuild Index Task Executing query "USE [adalib] ".: 2% complete End Progress Progress: 2012-07-22 00:29:30.23 Source: Rebuild Index Task Executing query "ALTER INDEX [A10_FL00001] ON [dbo].[A10] REBUILD P...".: 2% complete End Progress Progress: 2012-07-22 00:29:30.23 Source: Rebuild Index Task Executing query "USE [adalib] ".: 2% complete End Progress Progress: 2012-07-22 00:29:31.20 Source: Rebuild Index Task Executing query "ALTER INDEX [A10_FL00002] ON [dbo].[A10] REBUILD P...".: 2% complete End Progress Progress: 2012-07-22 00:29:31.20 Source: Rebuild Index Task Executing query "USE [adalib] ".: 3% complete End Progress Progress: 2012-07-22 00:29:32.07 Source: Rebuild Index Task Executing query "ALTER INDEX [A10_FL00003] ON [dbo].[A10] REBUILD P...".: 3% complete End Progress Progress: 2012-07-22 00:29:32.07 Source: Rebuild Index Task Executing query "USE [adalib] ".: 3% complete End Progress Progress: 2012-07-22 00:29:33.23 Source: Rebuild Index Task Executing query "ALTER INDEX [A10_FL00004] ON [dbo].[A10] REBUILD P...".: 3% complete End Progress Progress: 2012-07-22 00:29:33.23 Source: Rebuild Index Task Executing query "USE [adalib] ".: 3% complete End Progress Progress: 2012-07-22 00:29:34.42 Source: Rebuild Index Task Executing query "ALTER INDEX [A10_FL00005] ON [dbo].[A10] REBUILD P...".: 3% complete End Progress Progress: 2012-07-22 00:29:34.42 Source: Rebuild Index Task Executing query "USE [adalib] ".: 4% complete End Progress Progress: 2012-07-22 00:29:35.58 Source: Rebuild Index Task Executing query "ALTER INDEX [A10_FL00006] ON [dbo].[A10] REBUILD P...".: 4% complete End Pro... The package execution fa... The step failed. ???

Hi, Go to the maintenance plan, double click the faulty task, there's a button to show the underlying the T-SQL code. Paste that code into an SSMS query and run it manually.Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

the script took over ten minutes to generate, but I eventually was able to run it and it succeeded manually. the script took over 20 minutes to run. it is possibly a timeout problem????

Hi berli, There are many possible causes for a package to stop running. This message might appear because of one of the following problems: 1. The data sources, files, or credentials that were specified on the development computer are not available or are not valid on the computer on which the package was deployed. 2. Data providers that were available on the development computer are not available on the computer on which the package was deployed. Or, data providers that were available in 32-bit versions are not available when the package is run as a 64-bit package. 3. The permissions that are required by the package are not sufficient when the package is scheduled in a SQL Server Agent job. For more information about the issue, please see: http://www.microsoft.com/technet/support/ee/transform.aspx?ProdName=SQL%20Server&ProdVer=10.0&EvtID=12291&EvtSrc=SQLISPackage100&LCID=1033 Thanks, Eileen

Hi, I don't think it is a provider problem since it looks like you're querying msdb and local user dbs. please check the rights of your domain admin account on the sql server for roles and user mapping. Remember that to execute ALTER INDEX, at a minimum, ALTER permission on the table or view is required. Have you tried executing the SQL from this job step from a query windows ? Did it complete ? Cheers Regis

as I said above, the script took over ten minutes to generate, but I eventually was able to run it and it succeeded manually. the script took over 20 minutes to run. it is possibly a timeout problem? the job succeeded in running automatically this week, after having failed for several weeks in a row. it looks like the manual run fixed something.???

the job is automatically generated by the maintenance plans of sql server. it ran fine until several weeks ago and then stopped. it ran fine this week after I ran the script manually???