void init()

in src/main/groovy/grails/plugins/quartz/cleanup/JdbcCleanup.groovy [22:46]


    void init() {

        log.info "[quartz-plugin] Purging Quartz tables...."

        def queries = []
        queries.add("DELETE FROM QRTZ_FIRED_TRIGGERS")
        queries.add("DELETE FROM QRTZ_PAUSED_TRIGGER_GRPS")
        queries.add("DELETE FROM QRTZ_SCHEDULER_STATE")
        queries.add("DELETE FROM QRTZ_LOCKS")
        queries.add("DELETE FROM QRTZ_SIMPLE_TRIGGERS")
        queries.add("DELETE FROM QRTZ_SIMPROP_TRIGGERS")
        queries.add("DELETE FROM QRTZ_CRON_TRIGGERS")
        queries.add("DELETE FROM QRTZ_BLOB_TRIGGERS")
        queries.add("DELETE FROM QRTZ_TRIGGERS")
        queries.add("DELETE FROM QRTZ_JOB_DETAILS")
        queries.add("DELETE FROM QRTZ_CALENDARS")

        def sql = new Sql(dataSource)
        queries.each { query ->
                log.info("Executing " + query)
            sql.execute(query)
        }


    }