The process, we are running works through 50 records each day from the Queue.
Assuming today after 10 records the process fails, there are 40 records which are still in New status. When the process runs tomorrow, we have to process the 50 records and not the 40 records which are still sitting in the queue in “New” status.
The logic need to be like if there are any pending items in new status from previous day, delete them(or ignore those from processing next day by some way), and then adds new items to the queue.
I understand only way to move queue item to in-progress is by getting that transaction item and that way it can be added again with new status and processed the next day.
However, I would like to know if there are better ways of achieving this?
Please note: bot/user doesn’t have delete privileges on queue.