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.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Data Driven Subs

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]
Go to Top of Page
   

- Advertisement -