Last post Mar 24, 2020 07:59 PM by bruce (sqlwork.com)
Mar 24, 2020 07:36 PM|rgovindarajan|LINK
I'm currently consuming external Rest API in my application to post data over.
I am using web api controller to do that.
For any errors and failed transactions, I have to resend it again. So I'm thinking a nightly batch process using SSIS to resend the data again.
Is there any better approach to handle the failed transactions ? Please advise.
Mar 24, 2020 07:59 PM|bruce (sqlwork.com)|LINK
it all depends on the tools you have. an outage may require several hours of retrying. a daily or hourly retry is common. you can use any scheduler and code.