Is there a way to retrigger messages for Azure Function SQL Trigger

Question

I have a function app that uses SQL trigger there was an issue with the main class location and my function app did get triggered but failed due to the exception that main class was not found.

The issue is fixed but I see that there are messages in the leases table but I want to know if these can be retried :

Answer 1

Hi @Shruti,

The SQL Trigger binding works by a polling strategy against the Leases table. In order to retry, you can set the _az_func_AttemptCount column to 0, see https://github.com/Azure/azure-functions-sql-extension/blob/main/docs/BindingsOverview.md#function-or-binding-exception-retries, for the changes you want to reprocess.