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?
Thanks
VinnieIn 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!
-PatP|||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?
Thanks
Vinnie|||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
other post.|||Ohhh..you mean this Link (http://support.microsoft.com/default.aspx?scid=kb;en-us;326485)
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.
Vinnie
Friday, March 23, 2012
Optimizations job failure
Labels:
appreciated,
backup,
backuptransactionlog,
created,
database,
errori,
failure,
job,
maintenance,
microsoft,
mysql,
optimizations,
oracle,
plan,
resolving,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment