SSRS Report Execution time different to Schedule Subscription time

Question

Hi everyone.
I am having trouble diagnosing an issue with an SSRS schedule.
It runs once a week at 0130 but the execution logs suggest it executes regularly around 0146.

I have tried the following but I found no clue as to what this may be:

• Perfmon trace on general server stats - nothing unusual found
• Perfmon trace on SSRS specific stats - nothing unusual found
• Run the report subscription manually - runs ok
• Run the report subscription at a different time - runs ok
• Run the report schedule every 5 minutes - runs mostly ok

There are times during the day that the report is slightly delayed by a minute or so but again, I see nothing in the Perfmon trace that would suggest that there's an issue with resources or request numbers.

Any ideas on what I could do to track down this annoying problem?

Thanks in advance!

Answer 1

Hi,
Rarely see this kind of behavior, did you check the logs if the report was successfully sent at 0130 or later as shown?
Was this a repetitive behavior that occurs each time at the subscription at 01:47 exactly?
It could be that , your server schedule at 01:30 other heavy works, so there is not enough resource to deal with the subscription.
Could you try delete the subscription and remake it with new made schedule, see if it works?
Any error or exceptions have you found at 0130 in report server trace log?
Regards,
Joy