Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
The data factory schedule trigger stops working
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 45%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJX%3C/text%3E%3C/svg%3E)
Jean Xavier Jasienski
0
Reputation points
Hello,
It is not the first time I encounter that specific problem regarding triggers: a daily trigger is set up to be launch at a certain time every day, but with no apparent reason, it stops running.
Here below, you can see that the last run was on 8/10/2023. With no reason, it didn't work for the 7 following days. The was no 'Specify an end date' set on the trg_daily and the 'Statuts' remained Started.
I didn't get any alert for this mistake which is quite annoying to discover later.
Is there any solution for this issue?
Azure Data Factory
{count} votes
-
Amira Bedhiafi 41,121 Reputation points Volunteer Moderator2023-08-17T11:54:57.2933333+00:00 Since you didn't provide more information you need to investigate by checking the logs for errors, verifying time zone settings, reviewing the trigger's configuration, and monitoring system resources. Ensuring that there are no permission issues and considering the implementation of an alerting mechanism or health check could also help you identify and resolve the problem. If these approaches do not work, you may need to recreate the trigger or contact the support team for your specific data factory product.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache 20,676 Reputation points Moderator2023-08-22T17:35:01.1433333+00:00 Hello @Jean Xavier Jasienski Just checking if we are still connected on this discussion?
One of the scenario which makes the triggers to stop will be as below,
- There was an update on the Trigger at the time it was expected to run.
We can sure setup monitoring alerts based on the collected logs.
-
QuantumCache 20,676 Reputation points Moderator
2023-08-29T07:07:36.48+00:00 Hello @Jean Xavier Jasienski Just checking if we are still connected on this discussion?
Sign in to comment
Sign in to answer