Table of Contents
Introduction
The Scheduler Plugin is a userview menu for Joget Enterprise and Professional to schedule jobs to run at a specific date and time. You can use this plugin to trigger any process tools (except the Form Data Update Tool, which runs only in a process flow).
...
This plugin source code is available in a new open-source repository at https://github.com/jogetoss/. JogetOSS is a community-led team for open-source software related to the Joget no-code/low-code application platform. Projects under JogetOSS are community-driven and community-supported, and you are welcome to contribute to the projects.
| Warning |
|---|
This plugin is not compatible with Joget Cloud and was designed to work only in Joget On-Premise. |
Plugin Info
Plugins Available in the Bundle:
...
5. In this example, we will create a task that creates a new record every day at 00:00.
Figure 4: Filling up the form
Scheduler Menu Properties
Figure 5: Scheduler Menu Properties
Configure Scheduler
| Name | Description |
|---|---|
| Job Name | Job label. |
| Cron Expression | A cron expression is a string comprising five or six fields separated by white space that represents a set of times, normally as a schedule to execute some routine. |
| App | Selected app. |
| Plugin | Select from a list of tools to schedule:
and many more. |
...
Do note that when you export an app, it will not include the scheduler records by default, so you will have to handle this separately. To ensure that your scheduled job configurations are successfully promoted across environments, you will need to perform a manual data export and import of the Scheduler data records, specifically for the sch_job_def table, which stores the Scheduler job definitions.
Here is how you can do it:
1
...
. Export the Scheduler Data:
- Use a database utility like SQLyog (for MySQL/MariaDB) or any other SQL client to connect to your Joget development environment's database.
- Export the contents of the
sch_job_deftable into a.sqlfile.
2
...
. Import the Scheduler Data:
- Connect to your test environment’s database using the same SQL client.
- Import the
.sqlfile into the test environment's database, ensuring that thesch_job_deftable is populated with the necessary job configurations.
3
...
. Edit and Start Scheduler Jobs:
- After importing the application and the
sch_job_defdatabase records into your Joget test environment, go to the userview where the Scheduler is configured. - Click to edit each scheduled job record to ensure the settings are correct, and then start the scheduler jobs as needed.
This process should successfully transfer your scheduled job configurations from the development environment to the test environment.
Download Demo App
- APP: APP_kb_scheduler_sample_app.jwa
- Scheduler Data: schedulerSQL.sql