sqlmaint.exe failed

[le1234]

currently have an optimization job with 1 step which keeps failing. When I view the job history all i get is the following error message:

sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

Is anyone able to help?

 

[ptheriault]

What does the maintenacne plan history say. If you open Management -> Maintenance Plans. Right click on the plan that is failing. Select view history.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[le1234]

that is the message in the maintenance history.

 

[ptheriault]

and it is the same error message in the job history? Does the SQL Server Agent Error log offer anything a bit more descriptive?

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[le1234]

sqlserveragenterrorlog:
[LOG] Unable to send job completion notification email to operator 'BOPSQL SQLBackup' for job 'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan FULL BOPSQL''

maintenance log looks ok, no errors logged until the last line:

End of maintenance plan 'DB Maintenance Plan FULL BOPSQL' on 21/01/2007 01:44:06
SQLMAINT.EXE Process Exit Code: 1 (Failed)

 

[ptheriault]

So it looks like your maint plan ran ok but failed trying to send the e-mail. What version of SQL is this. Have you tried to send a test email to that operator?

- Paul
- If at first you don't succeed, find out if the loser gets anything.