[SOLVED] Quartz Scheduler - What is the diff between RAM and JDBC Job store

Issue

I want to use Quartz Scheduler framework in my application. I came across two types of JobStores:

1) RAM Job Store

2) JDBC Job store.

I am wondering in which case I have to use which job store. And what is the pros and cons between them.

Any thoughts on this is really helpful for me and I appreciate it.

Solution

JDBC job store saves information about fired triggers and jobs in the database, thus:

• it won't lose firings if application was down when trigger was suppose to fire (this depends on chosen misfire instruction)

• you can cluster your scheduler, where each node uses the same database

• JDBC job store is considerably slower

RAM job store is applicable only in non-clustered application where loosing a firing is not a big deal. It's also much faster. If you want to use Quartz with RAM job store, most likely you don't need Quartz at all. Both Spring and EJB provide mechanisms to run periodic jobs, both time and CRON based.

Answered By - Tomasz Nurkiewicz