Add Multitenant Support to the Scheduler

[priyanshi19]

I want to add mutitenant support to the quartz scheduler that shares a single db but has multiple schemas as tenant. How do i configure the quartz scheduler in my spring boot application such that on runtime it is able to switch the tenant and perform scheduling and job execution in that same current tenant schema.

I have tried few things:-

1. Maintaining a tenantContext and adding a tenantAwareDataSource support through which i am able to schedule a job in the current tenant schema but it is not getting executed in that schema
2. Added triggerListeners and JobListeners to switch the context based on the tenant found in job data that also didn't work. Scheduler fails execution as it looks for default public schema for internal execution and these listeners never get implemented.

Please guide me on how to add multitenant support in scheduler.