SQL Server Performance

scheduled SQL server index rebuild job failed...

Discussion in 'General DBA Questions' started by matey, Sep 27, 2004.

  1. matey New Member

    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)
    matey, Sep 27, 2004
    #2

  2. satya Moderator

    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
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Sep 27, 2004
    #2

  3. matey New Member

    ok i'll give it a go and see what happens.
    matey, Sep 27, 2004
    #2

  4. Luis Martin Moderator

    Also check if XYZA is dbo table or user table.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

    Luis Martin, Sep 27, 2004
    #2

Share This Page