Find Snowflake task run history

--get task history:

select *

from table(information_schema.task_history(

scheduled_time_range_start=>dateadd('hour',-1,current_timestamp()),

result_limit => 10,

task_name=>'taskname'));

use database tasks;

select *

from table(information_schema.task_history(

scheduled_time_range_start=>dateadd('hour',-1,current_timestamp()),

result_limit => 10,

task_name=>'taskname'));

--query to check task history:

use role accountadmin;

select Name, State, scheduled_time, next_scheduled_time

from table(information_schema.task_history(

result_limit => 20));

--get list of all tasks;

use database dabase_name;

use schema schema_name;

show tasks;