Terracotta Discussion Forums

Hi,

I have used Quartz scheduler as a RAMJobStore. Now, I have following requirement in my project for supporting scheduler.

* Run time scheduler should allow user to schedule a new job, edit(update/delete) existing job.
* should be able to run 3000-4000 jobs simultaneously

Questions:

1. I have to schedule jobs runtime through UI interface. That means I may have to use JDBCJobStore. In that case, which option would be better - quartz as a standalone API or quartz scheduler intergration in spring framework?
2. What is the difference between Spring quartz vs quartz API?
3. which option is better for executing or scheduling 3000-4000 jobs simultaneously
4. Our application is using hibernate - does JDBCJobStore requires to create pojos for quartz tables?
5. how do I use persistence with spring? I have existing connection pooling and trasacation API in my application- can I have separate tranaction api for spring quartz scheduler? Any examples?
6. Do you know any users/application/website who is using spring quartz api?

Your help will greatly be appreciated. If possible, please provide me some examples as well.

Thanks in advance,

> 1. I have to schedule jobs runtime through UI interface. That means I may have to use JDBCJobStore. In that case, which option would be better - quartz as a standalone API or quartz scheduler intergration in spring framework?

I have no idea why this would mean you have to use JDBCJobStore.

Regarding Spring vs. no Spring, there are no advantages to using Spring (and no significant disadvantages) - so it would be a matter of which way it best works with the rest of your application (if you have an application that makes use of Spring, then it may be easier to use Quartz via Spring - but even then not necessary).

> 2. What is the difference between Spring quartz vs quartz API?

Same features. Spring wrappers just give you a Spring-like way of using Quartz.

> 3. which option is better for executing or scheduling 3000-4000 jobs simultaneously

No difference.

> 4. Our application is using hibernate - does JDBCJobStore requires to create pojos for quartz tables?

No. JDBCJobStore does all the SQL for you, would make no use of Hibernate, though would work fine along side it in the same app.

> 5. how do I use persistence with spring? I have existing connection pooling and trasacation API in my application- can I have separate tranaction api for spring quartz scheduler? Any examples?

This is a Spring question, not a Quartz question.

> 6. Do you know any users/application/website who is using spring quartz api?

There are thousands of them.

Thanks for your reply jhouse

I have not used Quartz, that is the reason so many questions.

1. Can you give me example where can I use JDBCJobStore? From the documentation I got that it is being used to persist the jobs. In my application, I have to store the jobs created/edited through UI interface. Can I store those in our own application DB instead of using Quartz DB and use RAMJOBStore?

2. Can quartz handle 3000-4000 jobs simultaneously? what would be the size of thread pool in that case?

3. can you point me some application/website where they use spring quartz?

Thanks in advance,

> 1. Can you give me example where can I use JDBCJobStore? From the documentation I got that it is being used to persist the jobs. In my application, I have to store the jobs created/edited through UI interface. Can I store those in our own application DB instead of using Quartz DB and use RAMJOBStore?

You can store stuff in your own DB and use RAMJobStore as long as your code loads the data from the DB and populates RAMJobStore with the info each time it starts.

> 2. Can quartz handle 3000-4000 jobs simultaneously? what would be the size of thread pool in that case?

Sure. Set the thread pool size to 4000 if you want 4000 to run at the very same moment. Or if you only need it to know about 4000, but only execute 200 simultaneously, then set the thread pool size to 200.

Whether it can actually run 4000 at a time or not will be a function of your hardware.

> 3. can you point me some application/website where they use spring quartz?

Don't know any off hand, but a quick google turns up several blogs with examples.

1. What do you mean by populates RAMJobStore with the info each time it starts?

2. what information do i need to populate in RAMJobStore and how? Is there API for it?

Thanks,

@nilishah

I've posted my comments to your questions on Spring forum. I just didn't wanted to duplicate it here.

They are not really centered around if you should use JDBCJobStore or RAMJobStore for your particular case but rather about Quartz/Spring integration.

http://forum.springsource.org/showthread.php?110113-spring-Quartz-intergration-run-time-job-in-scheduler

1. Your jobs are not persistent so when your app shuts down you'll lose all your jobs in case of RAMJobStore, so when app starts you need to reschedule them.
2. You'll need information to recreate the jobs.

Some more questions

1. Is there any difference maintenance wise between quartz and spring based quartz?
2. Is there any advantage of using "Quartz Where" if we have about 500-1000 jobs running simultaneously?
3. You can store stuff in your own DB and use RAMJobStore as long as your code loads the data from the DB and populates RAMJobStore with the info each time it starts.

-- Which API do I have to use to load the data from our DB and populates RAMJobStore?
-- With JDBCJobStore, for each restart of application, does it pick up the list of scheduled jobs on its own?
-- Can I have some columns integrated from Quartz tables to our DB and vice versa?
-- For list of around 3000-4000 jobs scheduled, maintenance wise which option would be better - RAMJobStore or JDBCJobStore?

Thanks,

@Nilishah,

I think you can answer many of your own questions by simply try out the Quartz API and code few examples of your own. You can add 3000 jobs to your own server using quartz easily and watch it run. You can down load Spring and read their API and it tells you what methods you can and can not do. If you can't do these on your own, there is no point in asking these questions.

You've answer my questions about the Run time scheduler.