...
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.
Instructions for the creation of the database itself are to be taken from the original database documentation. The JobScheduler setup program will create the necessary database tables if they do not already exist.
...
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.
...
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 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.
...
where postgres is the user name and scheduler is the database name. createlang is available from the PostgreSQL bin directory. If plpgsql is not be listed in the output of this command then please enable this language byusing:
| Code Block | ||
|---|---|---|
| ||
createlang -U postgres plpgsql scheduler |
...
For all those that do not want to change this globally, this setting can be changed on a per an inidividual user level:
| Code Block | ||||
|---|---|---|---|---|
| ||||
alter user scheduler set standard_conforming_strings = off; alter user scheduler set bytea_output = 'escape'; |
...