@Paul Riordan Thanks for reaching out.
As you have set the CRON expression to 0 0 0 * * *
which means that the function should trigger every day at midnight UTC. However, you mentioned that it has not been triggered for a week.
Can you please confirm if you don't see any other invocation for the last week as one of the possible reason for this could be that the timezone of your function app is not set to UTC. By default, the CRON expression runs based on Coordinated Universal Time (UTC). If you want to run the CRON expression based on another timezone, you can create an app setting for your function app named WEBSITE_TIME_ZONE.
You mentioned that you are using a Consumption plan, which means that the "Always On" option is not available. However, you can try restarting your function app to sync the trigger and if this doesn't work then you can try sync the trigger. For more details you can refer to the previous discussion here.
The other reason would be if the storage account is deleted/key changed or your are using multiple function app sharing the same storage account. For more details, please refer to this.
If the above doesn't work, then you can review the diagnosis and solve problem blade on your function app to know more details why the trigger was not triggered and the action plan if any to mitigate the issue.
Please "Accept Answer" if the answer is helpful so that it can help others in the community.