...
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_def
table into a.sql
file.
2
...
. Import the Scheduler Data:
- Connect to your test environment’s database using the same SQL client.
- Import the
.sql
file into the test environment's database, ensuring that thesch_job_def
table is populated with the necessary job configurations.
3
...
. Edit and Start Scheduler Jobs:
- After importing the application and the
sch_job_def
database 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