Page History

...

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 the sch_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