Automated Quartz task scheduler plays a key role in the calculation of analytics and performing other routine operations in bpm’online.
To ensure the continious operation of task scheduler, perform the following actions:
• Set up auto-monitoring for the installer application.
• Set up auto-run of SQL scripts to update the tasks in the DB.
Setting up auto-monitoring for the installer application
Monitoring of the availability of the installer application must be performed automatically every 5-10 minutes.
You can use several ways to set up the auto-monitoring for the application:
• Use any free online service for monitoring websites, for example, https://uptimerobot.com/.
• Use the Windows task scheduler to start the script for application monitoring.
Note
You can visit the bpm’online community to find an example of script for application monitoring.
Setting up auto-run of SQL scripts to update the tasks.
Tasks in the DB are updated automatically by running a special SQL script to update statuses of the running tasks in the Quartz system tables.
The SQL script to update the tasks must run every 30 minutes.
The SQL script can automatically run by using the SQL Server agent service.
Note
You can visit the bpm’online community to find an example of SQL script for task updating.