| Table of Contents |
|---|
It is required that the JobScheduler is allocated The JobScheduler Master requires a database and/or database schema and a database user.
See the Which Database Management Systems are supported by JobScheduler? article for detailed information about which DBMSs are supported.
except the JobScheduler is running as an agent. Instructions for the creation of the database itself are to be taken from the database documentation. MySql® MySql® (5.x ++), Oracle® Oracle® Database (8.1.x, 9.2, 10g, 11g), Microsoft® Microsoft® SQL Server (2000, 2005, 2012), PostgreSQL (8.x, 9.x), IBM® IBM® DB2 (8.x ++) und SybaseASE 15.0. are supported. The JobScheduler setup program creates will create the necessary database tables if the Database Support package is installed and the database connection is specified in the appropriate setup formthey do not already exist.
The setup also requires sufficient database permissions for the following statements: CREATE TABLE, CREATE INDEX, CREATE TRIGGER, INSERT,UPDATE,DELETE and SELECT statements.
The database configuration information is saved in the following configuration files:
...
Because of licensing restrictions a MySql® JDBC® Driver MySql® JDBC® driver is not provided. Please download a MySql® JDBC® driver MySql JDBC driver before you start the JobScheduler installer. Alternatively, the MariaDB® JDBC® driverMariaDB® JDBC driver, delivered with the JobScheduler setup, can be used for MySql®MySql.
3.2
...
Microsoft SQL Server and Sybase
Because of licensing restrictions when used with Sybase or Microsoft® Microsoft SQL Server databases, a JDBC® JDBC driver appropriate to suitable for the database version being used must be provided by the end user users themselves. Alternatively, a jTDS JDBC® JDBC driver, delivered with the JobScheduler setup , can be used for Microsoft® Microsoft SQL Server and Sybase databases. Otherwise please download a Microsoft® Microsoft SQL Server or Sybase JDBC® JDBC driver before you start the JobScheduler installer.
If you want to use a Windows domain user instead of an sql user SQL user for the Microsoft® Microsoft SQL Server connection then please read the How to connect to an SQL Server with a domain account article for more details.
...
PostgreSQL requires PL/pgSQL. Check the languages that are available for your database by using:
| Code Block | ||
|---|---|---|
| ||
createlang -U postgres -l scheduler |
where "postgres" is the user name and "scheduler" is the database name. "createlang" is available from the PostgreSQL bin directory. Should "If plpgsql" is not be listed in the output of this command then please enable this language by:
| Code Block | ||
|---|---|---|
| ||
createlang -U postgres plpgsql scheduler |
...
where "scheduler" is the user name of the JobScheduler database.
IBM DB2
For IBM® DB2 you have to provide a license file for the driver too. As this driver will also be required by the JobScheduler later on, it will copied by the setup into the $SCHEDULER_HOME /lib/user_lib folder.
| Anchor | ||||
|---|---|---|---|---|
|
...
SQL scripts which create the database tables required by the JobScheduler are available , should 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).
...