Post reply

Multi Server Job Errors

  • November 2, 2006 at 7:31 am

    #170271

    I have a multi server database backup job.  One of the target servers is failing to run the job, and I can't see why.  How can I log the output of a target server's job to a file (the log file option is disabled)?

    Thanks.

  • November 2, 2006 at 8:36 am

    #669509

    Right click the job in EM and choose ViewJobHistory

    Kindest Regards,

    Vasc

  • November 2, 2006 at 9:20 am

    #669534

    All that tells me is the last step to run, it doesn't give me any details of why it is failing......I need to be able to right the errors to a log file, like I can for single server jobs.

  • November 2, 2006 at 12:45 pm

    #669600

    To view the job history

    1. In the details pane, right-click a job, and then do one of the following:

      • Click View Job History if you are viewing the history of a local job.
      • Click Job Status if you are viewing the history of a multiserver job.

    2. If you clicked Job Status, in the Multiserver Job Execution Status dialog box, click Job, click a job name, and then click View Remote Job History.
    3. To update the job history, click Refresh.

     

    Also check in right upper corner ShowStepDetails

    Kindest Regards,

    Vasc

  • November 2, 2006 at 2:11 pm

    #669616

    thanks for the suggestion, but this is all that I see "sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029).  The step failed." for the reason.......the job backs up the database fine, but we can't find why it is failing every once in a while.....any suggestions?

  • November 2, 2006 at 2:24 pm

    #669620

    Normally, the information from the job history is not enough. I would like to recommend you add an output file in your job.

    Open the properties of your desired job;

    Goto Edit;

    Click Advanced tab;

    You will not miss it (output file).

     

  • November 2, 2006 at 2:55 pm

    #669631

    That's what I was wanting to do originally, but on a job that comes from a multi server job, you can not get it to go to an output file.....the outfile feature is disabled.

  • November 3, 2006 at 9:53 am

    #669852

    The error: [SQLSTATE 42000] (Error 22029) is kind of generic and kind of not. It may be a login/authentication error. You may want to check the system event logs on the target server for the time to get a better clue as to what is going on.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy