SQLServerCentral.com Content tagged Blogs, SQL Agent

Monitoring SQL Server Agent job run times

Wed, 01 May 2013 06:00:00 UT

Introduction A few months back, I was asked how long a particular nightly process took to run. It was a super...

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Startup Jobs

Wed, 08 Aug 2012 06:00:00 UT

Are there things you need to make sure are running when your SQL Agent starts? Did you know that you...

Configuring Auto-Retry on SQL Server Agent

Mon, 01 Jun 2009 06:00:00 UT

The goal of this post is to explain how to take advantage of Auto-Retry and why you will want to use it. I hope to clarify in which circumstances an auto-retry works best and when not to use it also. The (disclaimer!) point is that every job has its own constraints, requirements, and has to be evaluated individually for whether an auto-retry will work. I will try and keep this summary short and crisp, but still with enough detail to understand auto retry best.