Camunda process to monitor the Database table as a batch for every 5 mins

Camunda 7 Topics Discussion & Questions
1

Hi All,

Need some suggestions on creating a Camunda process as Batch program to monitor a database table.

Please provide any sample example

Thanks,
Sri

2

Hi Sri,

Iā€™m not sure that you are looking for. Based on the short description, you can simply model a process with a timer start event with a time cycle:

You may want to use external tasks to do the monitoring stuff.

Best regards,
Philipp

1 Like
3

Thank you,

I have specific question, I need to monitor a list of TaskID for the camunda process, if the TASK ID is not getting process for more 1 hpur or so, notify to the team about it.

Do you have any existing table in Camunda, Where the TaskID status are maintained where it is running state and completed state.

Please provide the specific table name and query to check if the Transaction ID is not completed for more than hour

Thanks,
Sri

4

Hi Sri,

the process engine stores the task data in table ACT_RU_TASK. You can find the historic data in the table ACT_HI_TASKINST.

You can use the TaskService / HistoryService to retrieve the data.

Note that you can also attach a timer boundary event to the user task which triggers the notification.

Best regards,
Philipp

5