In cases where the data changes constantly it would be certainly useful.
Take a look at the image below:
We can see a lot of failed status in the Queries Queue » Done list.
Notifying the author or somebody that the query is failing would prevent the scheduler being overloaded with queries that did not work anymore.
