Skip to content

Instantly share code, notes, and snippets.

View fl00r's full-sized avatar

Peter Yanovich fl00r

33 followers · 9 following
  • yandex
  • Moscow
View GitHub Profile
@fl00r
fl00r / quartz_jdbc_store.sql
Last active August 29, 2015 14:26 — forked from ajbrown/quartz_jdbc_store.sql
The following script creates the schema required to use Postgres as the JDBC store for clustering Quartz. This was tested on Quartz 2.2.1 in Postgres 9.1 and 9.3
DROP TABLE qrtz_blob_triggers;
DROP TABLE qrtz_calendars;
DROP TABLE qrtz_cron_triggers;
DROP TABLE qrtz_fired_triggers;
DROP TABLE qrtz_job_details CASCADE;
DROP TABLE qrtz_locks;
DROP TABLE qrtz_paused_trigger_grps;
DROP TABLE qrtz_scheduler_state;
DROP TABLE qrtz_simple_triggers;
DROP TABLE qrtz_simprop_triggers;