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