Maintenance plan fails to run optimize and integrity jobs

[Harry Brink]

I am having two of my maintenance jobs fail. I chose the
optimize and integrity check boxes, etc., and scheduled
the jobs using enterprise manager. They have been running
fine for over a year and have now stopped, but only on one
database. They work fine on numerous other databases on
our system. We are running SQL 7 7.00.842. I have tried
deleting the jobs, the maintenance plan, and recreating it
several times to no avail. I have run dbcc checkdb and
other dbcc commands and cannot locate any data errors. I
receive the following error message in my output file:

[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column
specified is outside the range of the specified query
result set.
Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]

Thanks in advance,
Harry

[Reinaldo Kibel (MS)]

Harry,

It most likely means sqlmaint.exe is expecting some columns from the result
set of some query which did not actual return those columns.
1) Use SQL profiler to trace the query when that error occurs. Run that
query in isqlw and see what happens.
2) find the matching JOB that is running the maintenance plan. Edit the job
properties and select the job steps. Under the advanced tab, enter a valid
file name on the Output for the job. After the maintenance plan runs again,
this file should give you better error message.

3) Some known issues with Maintenance plan
Q276234 FIX: SQLMaint.exe Sets Database Status Incorrectly
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q276234

Reinaldo Kibel
Microsoft® Corp. - SQL Server Support Engineer

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.

Additional support can be obtained at http://support.microsoft.com

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--------------------
| Content-Class: urn:content-classes:message
| From: "Harry Brink" <hbr...@wirb.com>
| Sender: "Harry Brink" <hbr...@wirb.com>
| Subject: Maintenance plan fails to run optimize and integrity jobs
| Date: Tue, 19 Mar 2002 09:00:02 -0800