BPEL Database Polling - How to limit the number of rows per interval?
Hi,
I'm trying to create a bpel database polling process to process a single table and use a logical update (mark a column as processed). The table will contain many unprocess records at any time. I want to be able to setup the polling interval so that it will only pick up the first 10 records for each polling interval. How do you create a polling process that will only process a limited number of records for each polling interval? Also, I'm using MS SQL Server 2005 for the table to be polled.