CODEWITHSUNDEEP
snowflake-cloud-data-platform
SRaj
SRaj

Reputation: 11

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?

Upvotes: 1

Views: 388

Answers (1)

NickW
NickW

Reputation: 9768

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 *

Upvotes: 1

Related Questions