Post reply

Better SQL Server Agent Job Failure Monitoring

  • October 26, 2020 at 9:00 pm

    #3801477

    Thank you very much for this post! I did not know that the history for jobs could be increased so easily. We are reviewing the provided code for use in our environment as well.

    Thanks again!

  • October 28, 2020 at 3:45 pm

    #3802130

    When you say "The SQL code to add to the job is shown here:" do you mean add it to the end of the job or where?

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • October 28, 2020 at 3:49 pm

    #3802132

    I just created a new SQL Server Agent Job and pasted in the code (making a few changes for my environment, and consolidating the emails so that only one is sent with all of the failed jobs instead of one email per failed job). Then I have the job run at 8 am every morning.

  • October 29, 2020 at 4:27 pm

    #3795629

    Comments posted to this topic are about the item Better SQL Server Agent Job Failure Monitoring

Viewing 4 posts - 1 through 3 (of 3 total)

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