Retry mechanism with JDBC type Data Source

[_SnowDeveloper]

Hello All,
We have setup a JDBC type Data Source And one scheduled import we have configured to run that daily.
We have a requirement to retry the execution 3 times in the interval of 10 mins if the connection fails and create one incident.
Please let me know if any one have idea how to achieve this.
Thanks

[Dr Atul G- LNG]

Hi @_SnowDeveloper 

https://docs.servicenow.com/bundle/vancouver-build-workflows/page/administer/flow-designer/concept/r...

I guess for this , need schedule job/ flow designer to check the import status and create record. 

[_SnowDeveloper]

Hi @Dr Atul G- LNG 

Thank you for your help.

We have JDBC type data source and we are not using connections and credentials.

Is there any way to run the transform 3 times with the interval of 10 mins and create incident on connection failure through scheduled import?

[Dr Atul G- LNG]

Hi @_SnowDeveloper 

I am not a pro but can give you a way.

- Write a schedule job or flow with wait condition.

- Check the 1st transform map, if result is pass then no need to run the job

else run the job after 10 mins.

- at 3 attempts , if transform status = fail, create an incident. 

I think, flow is best way to do.

[Dr Atul G- LNG]

Hi @_SnowDeveloper 

https://www.servicenow.com/community/incident-management-forum/implement-retry-mechanism-in-schedule...

https://www.servicenow.com/community/developer-forum/connection-timeout-setting-for-jdbc-data-source...