Page History

...

• 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/sos_settings.ini (Used by the script ./install/scheduler_install_tables.(sh|cmd) and some JITL jobs)

• 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

If you are using the Managed Jobs then you have to configer as well the file ./web/custom/custom_inc.php.
See here.

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

MySQL

factory.ini:

 [spooler]
 ...
 db                     = jdbc -class=com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/scheduler -user=scheduler -password=scheduler
 db_class               = SOSMySQLConnection
 ...

...