var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Optimizations job failure
Anyone's help is appreciated in resolving this error:
I created a Database Maintenance plan with backup+transactionlog backup+ optimizations. The first two jobs run fine but optimizations job fails with:
sqlmaint.exe failed [SQLSTATE 42000] ( Error 22029). The step failed.
The user that is running all the jobs is "sysadmin" in database and member of administrator on local machine.
I am trying to run this when the users are using the system.
Any thoughts how I can fix this?
In the Job History dialog box, check the "show details" box in the upper right corner. If you know why the job failed, you'll have a much better shot at fixing it!
Thanks for the suggestion. The error message I wrote down is from the steps details after checking the box on right hand corner and looking through the steps information why it failed. The step 1 gave that info
sqlmaint.exe failed. SQLSTATE 42000 error 22029. The step failed.
Any other thoughts?
OK What's the second line say?
This is the second line.
The first line was: The job Failed. The Job was invoked by User HBOCD01\VKaramc. The last step to run was step 1 (Step 1).
...I think you've posted this subject twice. Check out the link I posted in the
Ohhh..you mean this
Why don't you show us the code in one step that didn't fail, and one that did...
Thanks for the link. Though the resolutions expressed in the link text have only 2 workarounds for my problem, I guess I can work it out.