is your task there with failed state?
Also, do you mind sharing specifically what you did to make it fail? so I can try to reproduce the same steps here
No
Here is what I am running
CREATE OR REPLACE TASK my_info_schema_task6
WAREHOUSE = compute_wh
SCHEDULE = ‘USING CRON 30 2 ** ** ** America/Los_Angeles’
AS
SELECT COUNT(**) FROM INFORMATION_SCHEMA2.COLUMNS;
Schema2 is not valid so task fails
can you send the print with this query result?
SELECT * FROM TABLE(INFORMATION_SCHEMA.TASK_HISTORY()) order by COMPLETED_TIME DESC
instead of go to this dashboard, could you please open a new worksheet and run that command?
Yes
I do not see failed task in the results as it only goes back about an hour
this query it is supposed to return all failed tasks, is it returning empty?
here is a partial output
ok, let me try to refine this a little bit
SELECT * FROM TABLE(INFORMATION_SCHEMA.TASK_HISTORY())
where NAME = 'my_info_schema_task6'
order by COMPLETED_TIME DESC
But you can see that task has failed at 230am from the dashboard
when you execute the previous select, is something returned?
Nothing
what is the DB name that you are running your task?