5

SQL Server Broker Service with Active - Active replication in place

view full story
linux-howto

http://serverfault.com – 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 (HowTos)