Wait random number of minutes

Posted by TiborKaraszi on SQL Blog See other posts from SQL Blog or by TiborKaraszi
Published on Fri, 18 Oct 2013 10:37:00 GMT Indexed on 2013/10/18 16:05 UTC
Read the original article Hit count: 182

Filed under:
Why on earth would you want to do that? you ask. Say you have a job that is scheduled to start at the same time over a number of servers. This might be because you have an SQL Server Master/Target server environment (MSX/TSX) or you quite simply script a job and execute that script on several servers. You probably want to spread the load on your SAN and virtual machine host a bit. This is the exact reason I use this procedure. I frequently use MSX servers and I usually add a job step (executing this...(read more)

© SQL Blog or respective owner

Related posts about SQL Server Agent