Job failing please assist

  •  

    I job scheduled to run a maintenance plan everyday but although the maintenance plans goes through successfull my job fail with the error below please assist

    SQL Server 2000

    Product Version 8.00.760 (SP3)

    Executed as user: CORPORATE\sqlexec. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029).  The step failed.

  • Hello Faiyaaz,

    Please check the service ownership. I would suggest you to check the services of MSSQLServer and SQLAgent. May be they might have been started with the LOCAL System Account.

    Thanks and have a nice day!!!


    Lucky

  • Faiyaaz,

    First check the Job History for the SQL Agent Job that is failing (should have been one or more jobs created by your maintenance plan).  Then check your SQL Server Logs for the times round about when the job ran and failed for more (hopefully) detailed information.  Those should point you in the right direction as to the underlying problem.

    Good luck,

        -Patrick

    Patrick Purviance, MCDBA

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply