Thursday, December 17, 2009 11:43 AM
Problem: A "Select" query fetches 100 records from DB. I need to get the rowcount and batch them in 10 jobs(100/10) for reading. Basically a batch processing POC.
Solution should be in below steps:
1. Get the row count(Assume 100 records)
2. Divide the rowcount by 25, which gives 4 batches.
3. Need to run these 4 jobs , to read the values.
Can anyone you please provide sample code
Please use html tags to format code blocks.