Post reply

SSRS Data Driven Subscription Status

  • March 24, 2009 at 12:08 am

    #202556

    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

  • March 25, 2009 at 3:22 am

    #965856

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

    Thank you

  • May 15, 2009 at 7:26 am

    #995310

    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...

  • May 16, 2009 at 3:26 pm

    #995907

    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...

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply