// Use the table function "TASK_HISTORY()" select * from table(information_schema.task_history()) order by scheduled_time desc; // See results for a specific Task in a given time select * from table(information_schema.task_history( scheduled_time_range_start=>dateadd('hour',-4,current_timestamp()), result_limit => 5, task_name=>'MYTASK'));