Scheduler process using Bpel DB Adapter

Every now and then , we need a scheduler process to initiate the work flow.

There are different types of schedulers available in the market and different kind of implementations.

But there is one simple way to have a scheduler process , all we need to use is the Bpel DB adapter.


Create a table , with two columns , one POLL_ENABLE_FLAG and one POLL_TIME
A simple table with just columns.  Insert just only record  with values a (Y, Date)

Now create a DB poller to poll this table based on the flag and perform the Logical delete.

As part of LOGICAL DELETE , update the records in the table to same value.

Provide the values like polling frequency and other details. Make sure to mention the

Data base Rows/ XML Document as 1.

In case it is clustered environment , enable Distributed polling.

So now for every polling cycle, the record will be picked and the process can initiate the work flow.

Hope this post helps you...Please write to us in case you need more clarifications