It's similar to what you did in Oracle BPM 10g, but instead of the Global Automatic, you'd instead have your process start with a Start Timer event and in the event's Implementation tab - select the "Time Cycle" radio button.
Thanks a lot Dan for your response. But how to implement the "Timer Start" event as a poller which will execute a store procedure periodically?I didn't find any implementation in "Timer Start" event.
I can use a "Message Start" event and implement a DB Adapter service as poller. But I found DB Adapter poller is only used for a table not for Store Procedure.In Store Procedure I can check different condition in various table and if all condition satisfies then only create a instance.
That does mean the instance will get created as per the polling interval, whether changes happened in tables or not.I want even if the poller runs, the instances get created only if StoreProcedure condition satisfies.
One approach would be to have an Exclusive gateway following the Service activity. Depending on the data retrieved from your stored procedure, it would have one Sequence Flow that would go to an End Event and another that invoked a Subprocess that creates the instance in the process you wanted it to.