This is a status service that stores jobs status and output in a JDBC compatible database. BeyondCron is distributed with support for MySQL and PostgreSQL databases. With the inclusion of the the appropriate JDBC driver, and creation of the the required table, BeyondCron is able to support other databases.
Environment variables
| BEYONDCRON_STATUS_SERVICE |
JDBC |
| JDBC_CONFIG |
Name of a configuration file containing JDBC status service configuration variables. If not an absolute file name, BeyondCron will search BEYONDCRON_DIR_CONFIG, the directory in which bc-server was started, and ~/.JDBC_CONFIG for this file. Default is jdbc.dat |
Configuration variables
The following configuration variables can be defined within the JDBC_CONFIG file.
| url |
Database connection URL. |
| user |
Database user name. |
| password |
Database user password. |
| … |
Optional MySQL configuration properties. |
| url |
Database connection URL. |
| user |
Database user name. |
| password |
Database user password. |
| … |
Optional MySQL configuration properties. |
| url |
Database connection. |
| user |
Database user name. |
| password |
Database user password. |
| … |
Optional database configuration properties. |
Table
This service requires the following table:
| Table |
Required permissions |
| bc_status |
Select/Insert/Update/Delete |
with the following colums:
| Column |
Type |
Nullable |
Default |
Primary key |
| bc_name |
VARCHAR(2048) |
|
|
|
| bc_timestamp |
BIGINT |
|
|
|
| bc_start_timestamp |
BIGINT |
|
|
|
| bc_state |
VARCHAR(32) |
|
|
|
| bc_result |
VARCHAR(32) |
|
|
|
| bc_value |
INTEGER |
|
|
|
| bc_message |
TEXT |
|
|
|
| bc_trigger |
TEXT |
|
|
|
| bc_output |
LONGTEXT |
|
|
|
| bc_removed |
BOOLEAN |
|
false |
|
| Column |
Type |
Nullable |
Default |
Primary key |
| bc_name |
TEXT |
|
|
|
| bc_timestamp |
BIGINT |
|
|
|
| bc_start_timestamp |
BIGINT |
|
|
|
| bc_state |
TEXT |
|
|
|
| bc_result |
TEXT |
|
|
|
| bc_value |
INTEGER |
|
|
|
| bc_message |
TEXT |
|
|
|
| bc_trigger |
TEXT |
|
|
|
| bc_output |
TEXT |
|
|
|
| bc_removed |
BOOLEAN |
|
false |
|
| Column |
Java type |
Size |
Nullable |
Default |
Primary key |
| bc_name |
String |
>= 2KB |
|
|
|
| bc_timestamp |
long |
|
|
|
|
| bc_start_timestamp |
long |
|
|
|
|
| bc_state |
String |
32B |
|
|
|
| bc_result |
String |
32B |
|
|
|
| bc_value |
int |
|
|
|
|
| bc_message |
String |
>= 2KB |
|
|
|
| bc_trigger |
String |
>= 2KB |
|
|
|
| bc_output |
String |
>= 2MB |
|
|
|
| bc_removed |
boolean |
|
|
false |
|
If the user account has permission, BeyondCron will create the table if it does not already exist.
