SSRS Data Driven Subscription Status

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » SSRS Data Driven Subscription Status

SSRS Data Driven Subscription Status

Rate Topic

Display Mode

Topic Options

Author

Message

nil-364356

Posted Tuesday, March 24, 2009 12:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, December 10, 2012 11:36 PM
Points: 6, Visits: 241

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

nil-364356

Posted Wednesday, March 25, 2009 3:22 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, December 10, 2012 11:36 PM
Points: 6, Visits: 241

Anyone has a workaround on finding out how to alert users on the Data Driven Subscription Completion?

Thank you

Post #683133

Doug-895130

Posted Friday, May 15, 2009 7:26 AM

Forum 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

nil-364356

Posted Saturday, May 16, 2009 3:26 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, December 10, 2012 11:36 PM
Points: 6, Visits: 241

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 »

Permissions