Trying to run this quarterly (every 3 months) on the 1st of every month. So next run that the url below gives IS correct i.e. running 2024-07-01, 2024-10-01, 2025-01-01.
Went here to generate this http://www.cronmaker.com/;jsessionid=node061i5n9p38u5hsyaesgioir2t859213.node0?0
and ofcouse put in the time zone. But I keep getting error “Invalid schedule was specified. Please refer to the docs on what constitutes a valid schedule.”
create or replace task Task_DB.SCH_Quarterly
warehouse=sch_load
schedule='CRON 0 0 8 1 1/3 EST'
as call proc_1() ;