Question
Fetch and Process more than 10000 records through Obj-Browse
Hi All,
We have a requirement to close(Resolve) all the open/pending cases in the application which are not worked upon by for more than 2 months/ 60 days. We have built an agent to do all the processing and scheduled it to run once a week.
We are using Obj-browse to fetch the records, with MaxRecords parameter left blank and hence by default Obj-Browse returns 10000 records. However if there are more than 10000 records (approx. 25000), my question is what would be the advisable and best practice solution to handle such scenario.
We are thinking of multiple approaches:
Should we schedule the agent multiple times to execute all the cases?
Or should we leave it to executed once and the agent will pick up rest of the cases in next week's run?
Or should we have one time execution of activity after deployment to take care of all such open cases and then leave the agent to execute once as scheduled?
Or any other option?
Please share your thoughts and knowledge of similar scenarios you might have encountered in your respective projects/experience.
Many Thanks!!