Also if you need more info from the error you can start SQL Server Agent
to run from the command prompt with verbose logging like this...

sqlagent.exe -c -v

-----Original Message-----
From: Elecia Ezell [mailto:[Email Address Removed]
Sent: Wednesday, January 29, 2003 7:11 PM
To: LazyDBA.com Discussion
Subject: Maintenance jobs are failing


Hi all,
I am trying to execute my maintenance jobs that I created using the sql
wizard but they fail each time. When I view the job history this is the
error given.

Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE
42000] (Error 22029). The step failed.

I looked at the permissions on the extended stored procedure sqlmaint
and public user has exec permission. I am clueless as to what the
problem is. Any assistance would be greatly appreciated.

Thanks in advance,
Elecia

MS Sql Server LazyDBA home page