Running Quartz.net jobs from database table dynamically

Hi..

I'm using Quartz.net to create the scheduled jobs running in the background. So far I can manage to run the jobs from program where I manually add the jobs in the source codes. In fact, what I really need is to run the multiple jobs from the oracle database whereby my JOBS_TBL database table stores all the necessary jobs with various preferences(jobcode, jobname, CRONexpression, etc).

I understand that JobStore feature can be used to store the data in the database but we can't store the jobs details permanently and update the jobs dynamically. (Correct me if I'm wrong).

Now my question is how can I run the multiple jobs from my JOBS_TBL table that will be changing the trigger timing(CRON expression) occasionally and dynamically? Which kinds of methods or ways I should use? By the way, I'm using my own windows service and getting the jobs from database.

Thanks!

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

abhishek trivedi11y ago
Hi,

I dont think this will be possible to run the jobs from database itself.

Best you could do is if there is any change in database table where you are storing your jobs configuration then somehow notify your .net application and rerun that job with updated parameters.

In this that would be question like how you will update running job without affecting all the other jobs (only in case of multiple jobs running.)

Thanks.