We currently have two datacenters in Active - Active mode and using SQL replication between the two datacenters (with a small delay). I'm developing a new process that will use SQL Server Broker Service (external activator) to process a time-based job queue.
There are currently 1200 jobs and each one should be scheduled once every 15 minutes, so I decied to utilize
BEGIN CONVERSATION TIMER to schedule the jobs and an external activator to retrieve the message from the queue. In theory (and with some limited testing) everything appears like it would work properly.
So my question is related to SQL replication - in this scenerio,
- Would we want the queue tables replicated?
- Can they be replicated?
- How can I split the jobs (somewhat evenly) between both datacenters without risk of running the same job twice?
I'm just not real clear on this scenario and we want to avoid running the same job twice. I've searched and searched (Google mostly) but can't find anything relavent to my situation. Any clarification / direction on this issue would be greatly appreciated.