'SNOWFLAKE- Trying to run task on 2nd Tuesday of every month (USING CRON 0 15 8-14 * 2 UTC)- running for all days 8-14? Why?
I am trying to run the Snowflake task on the 2nd Tuesday of every month using (USING CRON 0 15 8-14 * 2 UTC). But it is running for all the days between 8-14. Why this behavior? Is this a known issue in snowflake?
Solution 1:[1]
there are plenty of online cron generators that will create cron strings for you.
This string should do what you want:
0 0 15 ? 1/1 TUE#2 *
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 | NickW |