Schedule Event Trigger in Data Model Errors immediately when Scheduled
I have created an event trigger in a data model, which I have done before without issue, but for this one as soon as I schedule the report that uses this data model and I use the schedule trigger, the report fails immediately with the following error.
Failed to execute event trigger::
I have added the SQL used in the Event Trigger below, which runs fine if you use it as the SQL for a Data Model. I am not sure why and there is no real detail to the error and running with diagnostic returns no diagnostic information on the error.