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

Shruti 20 Reputation points
2024-06-11T10:24:47.94+00:00

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 :

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,476 questions
0 comments No comments
{count} votes

Accepted answer
  1. Ryan Hill 26,771 Reputation points Microsoft Employee
    2024-06-11T13:44:18.2366667+00:00

    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.

    0 comments No comments

0 additional answers

Sort by: Most helpful