[JobServer Built In Database Support] JobServer Standard version comes with a built in HSQL database. Visit http://hsqldb.sourceforge.net for more information on HSQLDB. A HSQL database is integrated with JobServer. It needs no special configuration to use with JobServer. Keep in mind HSQL has limited scalability and concurrency support compared to databases such as Oracle and Postgresql. It is targeted at JobServer environments with the following conditions: - Managing under a several hundred Jobs - Limited number of concurrently running Jobs. - Number of concurrent users is relatively small When using JobServer Standard version, you will not have access to some of the extended threading features found in the core Professional version and you will also not have access to the distribute Agent feature that allows for running jobs in a distributed cluster environment. However you will have access to Mesos clustering. The HSQL database username/password are configured in the system-config.properties file. You can change the password of "JSUSER" by using the dbmanager gui tool (found in jobserver/bin/toolbin/dbmanager). Use the command: ALTER USER "JSUSER" SET PASSWORD "MY-NEW-PASSWORD" to change the password of "JSUSER" using this tool. The dbmanager tool can also be used as a general query and admin tool by an administrator to access the HSQL database. Normally the JobServer administrator will not need to deal directly with the HSQL database unless performing trouble shooting or performance tasks. [Database Maintenance] Table Trimming -------------- The JobServer database tables should normally be trimmed on a periodic basis. To do this, create a job using the pre-built TaskBean "JobServerCleanup" that comes with the installation. Create, configure, and schedule this Job. Run this job on a regular basis (for example weekly, monthly or as needed). It will keep the database trimmed to your specifications.