I have scheduling requirements where I place all my schedules in SQL db and then use the azure function every minute to read that database. When the schedule is met, I then perform a durable function for that schedule.
This causes a lot of Azure Functions to be invoked, and CPU usage also increases as this is continuously polling.
I am thinking about using Service Bus to replace this but creating a service bus message with delays.
But how reliable is Service Bus? Does it ever fail?
If a Service bus trigger was to fail for any reason, is that message deleted or would that message cause another trigger?