Skip to end of metadata
Go to start of metadata

If you want to change the database for the JobScheduler then follow these steps:

  • Create the new database
  • Stop the JobScheduler
  • Configure the new database connection data in the following files:
    • ./config/factory.ini (For JobScheduler tables like SCHEDULER_HISTORY. See factory.ini)
    • ./config/hibernate.cfg.xml (Used by JID and some JITL jobs)
    • ./config/reporting.hibernate.cfg.xml (Used by JOC; with release >= 1.11.0)
    • ./config/sos_settings.ini (Used by the script ./install/scheduler_install_tables.(sh|cmd) and some JITL jobs; with release < 1.11.0)
  • Call the script ./install/scheduler_install_tables.sh (for Unix) or ./install/scheduler_install_tables.cmd (for Windows).

    • This script executes the sql files in ./db/[dbms]/ to create the database tables.

  • Start the JobScheduler

Examples for the Configuration of factory.ini, hibernate.cfg.xml and sos_settings.ini

MySQL

factory.ini:

hibernate.cfg.xml and reporting.hibernate.cfg.xml:

sos_settings.ini:

MySQL via MariaDB

factory.ini:

hibernate.cfg.xml and reporting.hibernate.cfg.xml:

sos_settings.ini:

Oracle

factory.ini:

hibernate.cfg.xml and reporting.hibernate.cfg.xml:

sos_settings.ini:

Microsoft SQL Server

factory.ini:

hibernate.cfg.xml and reporting.hibernate.cfg.xml:

sos_settings.ini:

Microsoft SQL Server via jTDS

factory.ini:

hibernate.cfg.xml and reporting.hibernate.cfg.xml:

sos_settings.ini:

PostgreSQL

factory.ini:

hibernate.cfg.xml and reporting.hibernate.cfg.xml:

sos_settings.ini:

DB2

factory.ini:

hibernate.cfg.xml and reporting.hibernate.cfg.xml:

sos_settings.ini:

Sybase

factory.ini:

hibernate.cfg.xml and reporting.hibernate.cfg.xml:

sos_settings.ini:

Sybase via jTDS

factory.ini:

hibernate.cfg.xml and reporting.hibernate.cfg.xml:

sos_settings.ini:

Firebird

factory.ini:

hibernate.cfg.xml and reporting.hibernate.cfg.xml:

sos_settings.ini: