We've developed a scheduled import which will run daily to fetch data from Oracle DB . Based on the incoming data and some calculations it will create an Incident record in ServiceNow.
Now we want to add Retry logic when import fails due to below use cases -
1. When mid server is down -> run the import again after 5 mins interval [repeat 3 times] and then send an email if it fails all 3 times
2. When scheduled import shows error -> re-run the import 3 times and then send an email
3. When no data is available in oracle DB -> send email saying "incident creation not possible due to no data available in Oracle DB"
Any suggestions on how can we achieve this ?
