Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
wbcorbettsr
Starting Member
6 Posts |
Posted - 2007-06-13 : 09:51:27
|
I have vb code that I am triggering a Data Driven Subscription. The problem I am having is that I need to wait for the Subscription to finish before I go on to the next line of Code. I am Currently using SQL to query the Subscriptions table in the ReportServer Database. I am Checking the LastStatus field to see if the Subscription is done. But I've noticed that it doesn't always update the field when the Subscription is finished. for example some times that field will stay "Pending". Is there another way that i trap for the subscription being complete? |
|
michael.malmgren
Starting Member
3 Posts |
Posted - 2012-01-16 : 08:10:03
|
Hey, if this is still an issue you may use the sp_After_Email_Job helper. [url]http://www.fuel9.com/home/content/spAfterEmailJob[/url] |
|
|
|
|
|