Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151

    Unanswered: Optimization job problem

    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.


    PLZ HELP>

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Check by profiler what is going on on server during this job and what last statement was executed without success.

  3. #3
    Join Date
    Jan 2004
    Location
    Montreal, Canada
    Posts
    151
    How do u do this iam a beginner

  4. #4
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •