0

I have created an email subscription for SSRS report.

When I execute the report by the Subscription, it shows the job successfully completed. But, the email is not received as the report is still executing, because one of the tables is in lock. Once the lock is released I receive the email of report.

Shouldn't the job wait for the lock to be released and the subscription mail to be sent before marking it as complete?

bobs
  • 21,844
  • 12
  • 67
  • 78
paranjai
  • 531
  • 2
  • 5
  • 26

1 Answers1

0

The problem is that it's an asynchronous process. The job is recorded as started and it should get updated by the result of the subscription. Try going back and checking when a job has failed in the creation of the report or sending of the email. The status messages from the subscriptions are limited and usually just show the last message.

zahidhanif
  • 56
  • 1