Is there a way to view a given query’s execution log? For example, if I have a query that runs every day, is there a way to see a log of its execution everyday and also if it failed? For example, say I have query A that runs every day. Would love to see:
Monday = Query A ran successfully and returned these results
Tuesday = Query A failed to run because of a timeout
Thursday = Query A ran successfully and returned these results
That way I know there was an issue on Tuesday, and probably another issue on Wednesday since there was no log recorded.