I have an SSRS subscription which is meant to run once at 6:45 am. It normally takes just a few minutes to process, but occasionally (often on Monday mornings when the server is very busy) it takes over half an hour. When this happens, the report executes again after half an hour, meaning that eventually duplicate reports are sent out.
I've checked the Job, and it only has history of running once, at 6:45, duration 0 seconds, as is normal for SSRS jobs.
Looking in dbo.ExecutionLog I can see both exectuions, at 6:45 and 7:15.
So it looks like the SQL agent isn't doing anything wrong, and the issue lies with the report server's handling of the dbo.AddEvent command?
I've looked for other subscriptions which can take over half an hour and they do not send out a second report in the way this one does, so it appears to be specific to this one.
No idea where to look next!