Search code examples
crontasksnowflake-cloud-data-platformscheduler

Snowflake task to run the job every 2nd day of month (working day)

Snowflake task to be executed on every 2nd day of month (working day)and i need the Cron parameters for this.

Solution

  • There is no specific cron combination for this, but you could define:

    • A cron combination that runs every day.
    • A stored procedure that checks the rules you defined ("today is the second day of the month, and today is not a Sat/Sun"), before running the rest of the stored procedure.

    Have the Snowflake task call said stored procedure with said cron combination.