snowflake-cloud-data-platformsnowflake-task

Snowflake task with CRON not scheduled

I have created a Snowflake task like the one below,

CREATE or replace TASK staging.task_name
  WAREHOUSE = 'staging_warehouse'
  SCHEDULE = 'USING CRON 0 1 * * * UTC'
AS
    delete from staging....

but I dont the see task scheduled or executed looking at the task history

select *
  from table(information_schema.task_history(
    scheduled_time_range_start=>dateadd('hour',-10,current_timestamp()),
    result_limit => 10,
    task_name=>'task_name'));

I usually run task with minute based schedule and this is the first time using a cron schedule, what might I be missing here?

Solution

  • Can you enable the task and then run the query again?

    alter task staging.task_name resume;