[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.