Product Knowledge Base

Space shortcuts

Page tree

Versions Compared

Old Version 15

changes.mady.by.user Alan Amos

Saved on

compared with

New Version 16

changes.mady.by.user Alan Amos

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The database configuration information is saved in the following configuration files:

  • $SCHEDULER_DATA/config/factory.ini (used by JobScheduler) 
  • $SCHEDULER_DATA/config/hibernate.cfg.xml (used by JITL Jobs and JID) 
  • $SCHEDULER_DATA/config/reporting.hibernate.cfg.xml (used by the JobScheduler and JOC Cockpit if a separate Reporting Database is specified ) 
  • $SCHEDULER_DATA/config/sos_settings.ini (used by scheduler_install_tables.(sh|cmd))

Anchor
reporting-database
reporting-database

The Reporting Database

Up to versions 1.10.x of the JobScheduler, reporting-relevant data such as the task history was stored in the same database(s) as used by the JobScheduler(s) for operating data.

...

The Reporting Database should generally be installed before installation of the JobScheduler(s) is/are started as it is specified during the installation of the JobSchedulers that are to use it. However the JobScheduler configuration can be edited manually after installation if required. See the JobScheduler Master Installation - 7 - Manual Configuration article for more information.

Database Drivers

MySql®

Because of licensing restrictions a MySql® JDBC® driver is not provided. Please download a MySql JDBC driver before you start the JobScheduler installer. Alternatively, the MariaDB® JDBC driver, which is delivered with the JobScheduler setup, can be used for MySql.

Microsoft SQL Server and Sybase

Because of licensing restrictions when used with Sybase or Microsoft SQL Server databases, a JDBC driver suitable for the database version being used must be provided by end users themselves. Alternatively, a jTDS JDBC driver, which is delivered with the JobScheduler setup, can be used for Microsoft SQL Server and Sybase databases. Otherwise please download a Microsoft SQL Server or Sybase JDBC driver before you start the JobScheduler installer.

If you want to use a Windows domain user instead of an SQL user for the Microsoft SQL Server connection then please read the How to connect to an SQL Server with a domain account article for more details.

PostgreSQL

PostgreSQL requires PL/pgSQL. Check the languages that are available for your database by using:

...

where scheduler is the user name of the JobScheduler database.

IBM DB2

A license file for the driver is required for IBM® DB2. This driver is copied by the setup into the $SCHEDULER_HOME /lib/user_lib folder as it will also be required by the JobScheduler later on.

Anchor
manual-creation
manual-creation

Manual Creation of Database Tables

SQL scripts which create the database tables required by the JobScheduler are available if they not have been correctly created by the setup program. These scripts can be run using $SCHEDULER_HOME /install/scheduler_install_tables.(sh|cmd).

Ensure that the database connection is correctly entered in the $SCHEDULER_DATA/config/sos_settings.ini configuration file.