...
It is required that the JobScheduler is allocated a database and/or database schema and a database user 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® (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 creates the necessary database tables if the Database Support package is installed and the database connection is specified in the appropriate setup form.
The setup also requires a sufficient database permissions for CREATE TABLE, CREATE INDEX, CREATE TRIGGER, INSERT,UPDATE,DELETE and SELECT statements.
The database configuration information is saved in the following configuration files (page 36).:
$SCHEDULER_DATA/config/factory.ini(used by JobScheduler)$SCHEDULER_DATA/config/hibernate.cfg.xml(used by JID)$SCHEDULER_DATA/config/sos_settings.ini(used byscheduler_install_tables.(sh|cmd))
...
If you want to use a Windows domain user instead of a an sql user for the Microsoft® SQL Server connection then please read here the How to connect to an SQL Server with a domain account article for more details.
3.3 PostgreSQL
...
Ensure that the database connection is correctly entered in the $SCHEDULER_DATA/config/sos_settings.ini configuration file (page 36) configuration file.