0

I am using Quartz.net for my job scheduling. I have different databases for my application and each needs to be considered for job processing.

I have two questions:

  1. Can I use same scheduler for all my databases with different job triggers or one scheduler for each database? This is because the trigger time varies from database to database.

  2. What are the advantages of one over the other? Which approach is best suited for my problem?

Nathaniel Waisbrot
  • 23,261
  • 7
  • 71
  • 99
Vinoth
  • 2,419
  • 2
  • 19
  • 34

1 Answers1

0

I don't know quartz.net but I suppose this is the same as the java version.

As a scheduler instance can be bound to only one datasource, there is probably no way to achieve that. You'll need one instance per database.

The only way I can imagine is that you develop a new "connector" that merges the data from all the databases, but (much more difficult) it must also be able to save the data to the appropriated database...

Maybe you should create a Facade object that manages the list of Scheduler instances and exposes only this object to your application.

HIH

poussma
  • 7,033
  • 3
  • 43
  • 68