SQL Server Performance Forum – Threads Archive
scheduled SQL server index rebuild job failed…I get the following error message from a scheduled task that is meant to run this morning at 0500. Again this is SQL 6.5 any ideas why the index rebuild failed would be appreciated. Process Exit Code 1. …MV_CUSTOM09’Rebuilding indexes for table ‘XYZA’** Execution Time: 0 hrs, 10 mins, 11 secs **End of maintenance for database ‘MYDB01’ on Sun Sep 26 05:54:59 2004SQLMAINT.EXE Process Exit Code: 1 (Failed)
Being SQL 6.5 version the help is limited, try to rebuild the indexes from the query analyzer and see the results. If possible re-schedule the individual DBCC for this database alone instead of using Maint.plan. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
ok i’ll give it a go and see what happens.
Also check if XYZA is dbo table or user table.
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.