quartzScheduler(SchedulerFactoryBean) {
    autoStartup = false
    schedulerName = 'reporting_quartz'
    dataSource = ref('dataSource_qrtz')
    transactionManager = ref('transactionManager')
    jobFactory = ref('quartzJobFactory')
}

quartz:
    autoStartup: false
    jdbcStore: true
    scheduler:
        instanceName: reporting_quartz
        instanceId: AUTO
        skipUpdateCheck: true
    threadPool:
        class: org.quartz.simpl.SimpleThreadPool
        threadCount: 5
        threadPriority: 5
    jobStore:
        misfireThreshold: 60000
        class: org.quartz.impl.jdbcjobstore.JobStoreTX
        driverDelegateClass: org.quartz.impl.jdbcjobstore.StdJDBCDelegate
        useProperties: false
        tablePrefix: QRTZ_
        isClustered: true
        clusterCheckinInterval: 1000
    plugin:
        shutdownhook:
            class: org.quartz.plugins.management.ShutdownHookPlugin
            cleanShutdown: true
    triggerHistory:
        class: org.quartz.plugins.history.LoggingTriggerHistoryPlugin
    jobHistory:
        class: org.quartz.plugins.history.LoggingJobHistoryPlugin

def props = {
        validationQuery = "SELECT 1"
        validationQueryTimeout = 3
        validationInterval = 15000
        testOnBorrow = true
        testWhileIdle = true
        testOnReturn = false
    }

    dataSources {
        dataSource {
            url = "jdbc:mysql://my.url.com:3306/prod?zeroDateTimeBehavior=convertToNull"
            username = "username"
            password = "password"
            driverClassName = "com.mysql.cj.jdbc.Driver"
            dialect = org.hibernate.dialect.MySQL5InnoDBDialect

            properties props
        }
        qrtz {
            url = "jdbc:mysql://my.url.com:3306/qrtz?zeroDateTimeBehavior=convertToNull"
            username = "username"
            password = "password"
            driverClassName = "com.mysql.cj.jdbc.Driver"
            dialect = org.hibernate.dialect.MySQL5InnoDBDialect

            properties props
        }
    }