Reprocessing errored records in JDBC to RFC

Hi All,

I have scenario where data if flowing from JDBC to RFC and creating Sales order in SAP and updating the JDBC with success or failure depending upon result, all this is working fine.

I need to develop reprocessing where in user can reprocess the failed record. User want to have manual option of re processing failed records as well as automation for the same.

Please suggest best way to achieve this re processing functionality.

Thanks in advance