Better SQL Server Agent Job Failure Monitoring

  • 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!

  • 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."

  • 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.

  • 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