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.
Hall of Fame
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?
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)