'Snowflake tasks are not triggered by schedule since 13h UTC the 16th of march
I'm facing an issue with my snowflake instance.
No tasks are running anymore. This suddenly happened.
I can run my tasks manually, but the automatic schedule is not triggering anything since 13 UTC today.
Do you have the same behavior ?
Thanks all
EDIT:
I have two tasks that are scheduled the same way (several times in a day), same schema, same user. One ran until 1h14 AM the other one ran all day long (as expected)
SOLUTION : The only fix that I found was to recreate the task by doing and to make it run normally again.
To do so :
select get_ddl('task', 'TASK_NAME')
Execute the code provided by the query
Resume the task :
Alter task TASK_NAME RESUME
Solution 1:[1]
There was actually something, some of my tasks didn't resumed themselves after the snowplow bug fix : status.snowflake.com/incidents/jj1vgwvgxdqj
The only fix that I found was to recreate the task by doing and to make it run normally again.
To do so :
select get_ddl('task', 'TASK_NAME')
Execute the code provided by the query
Resume the task :
Alter task TASK_NAME RESUME
Thank you all for your help
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Stevens Laurent |
