Dynamically create listeners

[andreujuanc]

Hello,

Would appreciate any guidance on this.

My scenario: I have a lot of databases, each one it's a exact replica but for a different customer. Each DB can be on multiple servers. I can have more than one instance of my webapp.

Currently I have a job, that finds all my databases, servers, and connection strings and runs parallel certain tasks every 2 minutes in all DBs. I would like to change it to 30 min to reduce stress in some of the DBs and then add Service Broker Listener that run those tasks on only on those inserts.

Whats the best approach here? D:

Thanks

[Siliconrob]

Have you explored using Reactive Extensions? Monitor the changes from your databases, but then push the observations out as needed by using observables and streams.