Can we have a single scheduler with multiple databases?

[viveknuna]

I am using the Quartz 3.5.0 version in .Net 6 application. Its multitenant application. I use a dictionary with tenantId as the key and scheduler as the value. So based on the request for a given tenant, my code picks the respective schedule and works as expected.

Now I would like to have only a single schedule but multiple tenant databases ( which have quartz-related tables).

So I create an instance of schedule and at runtime based on the tenantId value I create a new schedule and assign it to the same schedule instance.

It's working fine. but there is an issue, jobs/triggers are created in the same database ( the one which is used for the very first request( only, ideally, it should point to the respective database.

[viveknuna]

@lahma do you have any inputs on this?

[viveknuna]

@jafin do you have inputs on this?

[jafin]

@viveknuna IIRC IScheduler is still a singleton, therefore to achieve this you may need multiple schedulers, but given the singleton constraint it may be a challenge. Take a look at #1453 , perhaps further investigation and if you are able to submit a PR may advance this?