Update on Pipedream not picking up missed tasks after schedule change to 6 hours?

Help
41

is your task there with failed state?

42

Also, do you mind sharing specifically what you did to make it fail? so I can try to reproduce the same steps here

43

No

44

Here is what I am running

45

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;

46

Schema2 is not valid so task fails

47

can you send the print with this query result?

SELECT * FROM TABLE(INFORMATION_SCHEMA.TASK_HISTORY()) order by COMPLETED_TIME DESC
48

image.png
image.png1666×489 34.4 KB

49

instead of go to this dashboard, could you please open a new worksheet and run that command?

50

Yes

51

I do not see failed task in the results as it only goes back about an hour

52

this query it is supposed to return all failed tasks, is it returning empty?

53

image.png
image.png1285×214 30.5 KB

54

here is a partial output

55

ok, let me try to refine this a little bit

56 
SELECT * FROM TABLE(INFORMATION_SCHEMA.TASK_HISTORY()) 
where NAME = 'my_info_schema_task6'
order by COMPLETED_TIME DESC
57

But you can see that task has failed at 230am from the dashboard

58

when you execute the previous select, is something returned?

59

Nothing

60

what is the DB name that you are running your task?