LISTING 1: Code That Increments StartTime Values

DECLARE @recurrence int
DECLARE @start_time int
DECLARE @stagger_interval int
DECLARE @db_name varchar(50)

SET @start_time = 001500   -- start time 00:15:00 minutes past midnight
SET @recurrence = 15       -- 15 minutes until the same job restarts
SET @stagger_interval = 2  -- 02 minutes until the next job starts on the next replicated database

DECLARE schedule_all cursor FOR
    SELECT name FROM master.dbo.sysdatabases 
    WHERE category = 1 -- select all replicated databases
OPEN schedule_all

FETCH next FROM schedule_all INTO @db_name

 WHILE @@fetch_status = 0
  BEGIN
    EXEC sp_SetLogReaderSchedule @db_name, @start_time, @recurrence
    SET @start_time = @start_time + 100 * @stagger_interval
    FETCH next FROM schedule_all INTO @db_name
  END

CLOSE schedule_all
DEALLOCATE schedule_all
GO