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:
...
This plugin bundle is compatible with Joget DX 7.0.7 and onwards.
Expected Outcome
To be able to create scheduled tasks inside the app through the UI menu.
Figure 1: Scheduler Menu
Get Started
Steps
Where to get the plugin
...
How to install and use the plugin
1. You can choose to create your own app or import the sample app below.
2. To access the Scheduler menu in your app, simply add a Scheduler menu inside your UI.
Figure 2: Scheduler UI Builder
3. Publish and run the UI.
4, Access the Scheduler Menu and create a new task.
Figure 3: Create a new task
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. |
Source Code and Plugin Download
For Joget DX Enterprise & Professional editions, you can download at the marketplace: https://marketplace.joget.org/jw/web/userview/mp/mpp/_/vad?id=scheduler_v6-1.
For source code,
- Please visit https://github.com/jogetoss/scheduler for the plugin source code.
- You can find the latest release at https://github.com/jogetoss/scheduler/releases.
- Upload the plugin to your Joget by navigating to Settings > Manage Plugins > Upload Plugin as admin.
Exporting Scheduler Data
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