SHOW tasks will show only 2 states ‘started’ or ‘suspended’. To view the past executions of task Realtime(without latency) task data of previous 7 days: https://docs.snowflake.com/en/sql-reference/functions/task_history

Task data for last 1 year with 45 minute latency: https://docs.snowflake.com/en/sql-reference/account-usage/task_history