Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Data Driven Subscription Status Expand / Collapse
Author
Message
Posted Tuesday, March 24, 2009 12:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 10:11 PM
Points: 6, Visits: 245
Hi,

I've got a data driven subscription set up which generates few thousand reports. This can take serveral hours. Users would like a nice email after subscription completes and also I need to execute the merge pdf once the dd subscription completes.

Is there any way I can insert trigger or similar which gets executed as soon as the Data Driven Subscription completes?



Thanks
Post #682087
Posted Wednesday, March 25, 2009 3:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 10:11 PM
Points: 6, Visits: 245
Anyone has a workaround on finding out how to alert users on the Data Driven Subscription Completion?

Thank you
Post #683133
Posted Friday, May 15, 2009 7:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 28, 2010 6:32 AM
Points: 1, Visits: 27
Just a thought... I don't see this functionality built into subscriptions, but there is a reporting services database with a table called 'subscriptions'. It has last execution time and status. I suppose you could put your trigger there... I haven't done this myself, but...
Post #717885
Posted Saturday, May 16, 2009 3:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 10:11 PM
Points: 6, Visits: 245
Thanks Doug for your reply.

I've done this trick and only works when you execute Subscription after first one completes. My requiremeent is to execute subscription multiple times on the fly. This seems to override the 'Last Status' field and first execution never gets reported correctly...
Post #718559
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse