SQL: Maintenance Plan Error “Server: Msg 22029, Level 16, State 1, Line 0 sqlmaint.exe failed.”

Earlier today, I discovered that the database maintenance plan on one of our SQL Server machine wasn’t working. When I reviewed the logs, it simply said “sqlmaint.exe failed”.

I ran the following command (copied from the SQL Server Agent job) using Query Analyzer (as this was a SQL Server 2000 machine):

The error returned, was:

(5 row(s) affected)

Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.

I tried running exactly the same command through the command-line:

This worked!!!

Both the SQL Server service, and the SQL Server Agent are using the Local Service account.

I have asked our server hosting provider to restart the server, as I have tried restarting the services, but still the maintenance plan doesn’t work through SQL Server Agent.

I shall update this post once the server has been restarted.

1 Comment

Add a Comment
  1. Hi.

    The server was rebooted overnight, and I can confirm that the maintenance plan jobs are now working.


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

CJayMead's SQL Server, Endeca, MS Office Help © 2018