I have several subscriptions that fail intermittently - some days they work, others they don't. I have looked through the SSRS log files but it is as though the subscription doesn't even start? There are no errors.
The status in the Subscriptions table simply says "Pending" or "The delivery extension for this subscription could not be loaded."
Has anyone come across this before?
I am running SQL 2008 R2 SSRS via Scaled-Out deployment across a cluster.