Step 1: Set up Quartz on PostgreSQL

Event information, such as scheduled reports, is stored in the Quartz JobStore. During the installation process, you must indicate where the JobStore is located by modifying the quartz.properties file.

1. Open the pentaho/server/pentaho-server/pentaho-solutions/system/quartz/quartz.properties file in any text editor.

2. Locate the #_replace_jobstore_properties section and set the org.quartz.jobStore.driverDelegateClass as shown:

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

3. Locate the # Configure Datasources section and set the org.quartz.dataSource.myDS.jndiURL equal to Quartz, as shown:

   This setting varies depending on the web server you have chosen for this installation:

   • If using JBoss, this setting should be:

     org.quartz.dataSource.myDS.jndiURL = jboss/datasources/Quartz

   • If using Tomcat, this setting should be:

     org.quartz.dataSource.myDS.jndiURL = Quartz

4. Save the file and close the text editor.