...
Instructions for the creation of the database itself are to be taken from the database documentation. MySql® (5.x ++), Oracle® Database (8.1.x, 9.2, 10g, 11g), Microsoft® SQL Server (2000, 2005, 2012), PostgreSQL (8.x, 9.x), IBM® DB2 (8.x ++) und SybaseASE 15.0. are supported. The JobScheduler setup program will create the necessary database tables if they do not already exist.
...
$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 byscheduler_install_tables.(sh|cmd))
...
| Anchor | ||||
|---|---|---|---|---|
|
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.
With version 1.11 and the introduction of the JOC Cockpit and JobScheduler Web Services, a separate Reporting Database can be optionally configured to act as central point of storage for the reporting information from a number of JobSchedulers, possibly operating on a number of hosts. The Reporting Database is accessed by the JOC Cockpit and/or another application via the JobScheduler Web Services. See the JOC Cockpit - Architecture article for more information.
The Reporting Database can be operated on a different DBMS to that used by the JobScheduler, within the DBMSs listed in the Which Database Management Systems are supported by JobScheduler? article.
The Reporting Database should generally be installed before installation of the JobScheduler(s) is/are started as it is then 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 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, 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, 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:
...
The following two PostgreSQL server variables must have the following values:
standard_conforming_strings = off- bytea
bytea_output = 'escape'
For all those that do not want to change this globally, this setting can be changed on a per user level:
| Code Block | ||||
|---|---|---|---|---|
| ||||
alter user scheduler set standard_conforming_strings = off; alter user scheduler set bytea_output = 'escape'; |
where "scheduler" is the user name of the JobScheduler database.
IBM DB2
For IBM® DB2 you have to provide a A license file for the driver too. As this driver will also be required by the JobScheduler later on, it will copied 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 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).
...