Home Forums Article Discussions Article Discussions by Author Discuss content posted by Richard Waymire Stairway to SQL Server Agent - Level 12: Using MSX/TSX to scale out Job Management RE: Stairway to SQL Server Agent - Level 12: Using MSX/TSX to scale out Job Management

  • April 21, 2014 at 10:20 pm

    #1707609

    Hi

    To stagger the jobs on the different target servers you would have to, in the 1st job step for example, have a 'randomizer' based on the host name.

    Eg:

    DECLARE @HostN VARCHAR(128) = @@ServerName

    IF @HostN = ServerA WAITFOR DELAY '00:01:00'

    Etc