I have this problem with my optimization job seems to fail all the time.
I have this set up as a sql maintenance plan and this is run 1 every week. i have checked for things that could comme in conflict but theirs nothing. here is the error i am getting from the job history step.
Executed as user: SAPCORP\adminsg. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
Originally posted by hillcat
How do u do this iam a beginner
From EM click on tools/sql profiler. Find last one from start/programs/microsoft sql server/sql profiler. Try books on line - i hope you do have it. It is difficult to describe how to use profiler in couple words - but it is really simple. For future you will have very powerful tool.