Quartz Job Scheduler Setup

Quartz Job Scheduler is used in various parts of the framework for running scheduled tasks. This section describes how to include Quartz in your project and set up its job store for different databases.

  1. Add the following dependency to the build.gradle file:

    implementation 'org.springframework.boot:spring-boot-starter-quartz'

  2. Add the following properties to the application.properties file:

    main.datasource.studio.liquibase.excludePrefixes = qrtz_
spring.quartz.job-store-type = jdbc

  3. If you are using PostgreSQL, add the following property:

    spring.quartz.properties.org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.PostgreSQLDelegate

  4. If you are using Microsoft SQL Server, add the following property:

    spring.quartz.properties.org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.MSSQLDelegate

  5. If you are using HSQL, PostgreSQL, MySQL or Oracle database, you can rely on automatic creation of the Quartz tables at the application start. Just add the following property:

    spring.quartz.jdbc.initialize-schema = always

  6. If you are using Microsoft SQL Server, you have to create the database schema manually, because the script provided by Quartz cannot be executed automatically by the Spring Boot mechanism. Follow these steps:

    • After adding the Quartz dependency (see above) and reloading Gradle project, find the tables_sqlServer.sql file inside the Quartz JAR. You can do it by pressing Shift twice (Navigate → Search Everything) in your IDE and entering the file name.

    • Execute the content of the tables_sqlServer.sql file against your database using a SQL client of your choice. Notice that you have to replace the enter_db_name_here placeholder in the first USE command with the name of your database.

    • Add the following property to the application:

      spring.quartz.jdbc.initialize-schema = never