October 27, 2014 at 10:21 am
Hi All,
I am working with one of ssrs report.
I subscribed the report for one time.
It created the job under the SQL Agent. The job is showing successful but when I saw my subscriptions under the report manager url the status is showing pending. Even from the executin logs the status is showing pending.
What is happening? The status is showing pending from more than 50 hrs. Is that report is still running or mail didn't go through or what is the problem?
I need some help to investigate this?
October 27, 2014 at 10:34 am
The only thing the SQL Agent job is going to do is create a record within your ReportServer database telling the SSRS engine that it has a subscription to execute. As long as that insert occurs the SQL Agent job will show successful.
After that it is on the SSRS engine to continue processing so any issues you have with this will require that you check the logs for SSRS.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
October 27, 2014 at 12:33 pm
Ok. Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply