OPEN SOURCE - Job Scheduler - Solutions for MySQL Jobs
|
|
|
|
| |
| |
|
MySQL Jobs
| |
MySQL jobs execute maintenance tasks and are included in the Job Scheduler distribution
in the
sos.scheduler.jar Java archive.
The source code of individual jobs is given below;
the complete source code is available in our download area.
MySQL jobs are included from the
scheduler_mysql.xml
configuration file by adding the <base file="scheduler_mysql.xml"/> element into the
scheduler.xml configuration file.
Maintenance
- Job: Check Table and Index Maintenance
As with all databases, tables and indexes have to be maintained from time to time.
This job performs the ANALYZE TABLE, OPTIMIZE TABLE
and REPAIR TABLE operations.
Show Job Documentation
Show Job Source Code
- Job: Monitor Replication
This job supervises the replication of a MySQL database using one master and an arbitrary number of slaves.
Administrators will be notified upon failure of the replication.
Show Job Documentation
Show Job Source Code
Scheduled Database Statements
- Job: Managed User Job
This job is used to execute database statements that have been submitted
via the SQL interface, similarly to what is done with the
Oracle dbms_jobs scheduling package.
This enables applications to launch SQL statements that should either be
executed at a later point in time or executed repeatedly.
For details see the documentation
MySQL Job Scheduling (HTML) (PDF).
Show Job Documentation
Show Job Source Code
|
|
|
|
|
| |
| |
Office Automation - Document Delivery - Job Scheduling - Systems Integration - Output Management - Enterprise Application Integration - Connectivity |
|
