Better SQL Server Agent Job Failure Monitoring

Question

Better SQL Server Agent Job Failure Monitoring

The xTEN Team

Old Hand

Points: 322
More actions
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

Data_Cat SSC Enthusiast Points: 198 More actions · Answer 1

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!

Caruncles Hall of Fame Points: 3299 More actions · Answer 2

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

Data_Cat SSC Enthusiast Points: 198 More actions · Answer 3

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.

Better SQL Server Agent Job Failure Monitoring

Cookies on SQLServerCentral