The reason I am asking this is because we have an app that processes the batch. Initially, all records have Processed values = 'N'. When the application runs, it scans BatchId per batchId, row per row. After the method is done for that row, it updates Processed='Y'. However, when it encounters an error, the app stops.
Therefore, I need to create a report which last batchId should I continue to resume my app running.