Wednesday, 28 August 2013

Offsetting the start time of SQL Server Agent job schedules between instances

Offsetting the start time of SQL Server Agent job schedules between instances

I have an agent job set to run log backups every two hours from 2:00 AM to
11:59 PM (leaving a window for running a full or differential backup). A
similar job is set up in every one of my 50 or so instances. I may be
adding several hundred instances over time (we host SQL Servers for some
of our customers). They all backup to the same SAN disk volume. This is
causing latency issues and otherwise impacting performance.
I'd like to offset the job run times on each instance by 5 minutes, so
that instance one would run the job at 2:00, 4:00, etc., instance two
would run it at 2:05, 4:05, etc., instance three would run it at 2:10,
4:10, etc. and so on. If I offset the start time for the job on each
instance (2:00 for instance one, 2:05 for instance two, 2:10 for instance
three, etc.), can I reasonably expect that I will get my desired result of
not having all the instances run the job at the same time?

No comments:

Post a Comment