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

update a table after data driven subscription complete Expand / Collapse
Author
Message
Posted Wednesday, August 28, 2013 12:59 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 11:38 AM
Points: 80, Visits: 357
I have to update a table after data driven subscription complete. Is it possible to add a new step to subscription job? Or is there any other better way?
Thank you
Post #1489389
Posted Thursday, August 29, 2013 7:20 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 8:21 AM
Points: 236, Visits: 2,657
Either that take a look at your datasource for the report and add the update to that query or stored procedure (as long as it is not shared with any other reports)
Post #1489710
Posted Tuesday, September 3, 2013 9:46 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:13 PM
Points: 257, Visits: 768
You could also setup some monitoring on the Subscription table in the ReportServer db, looking for successful resolution of the data-drive sub, and then kick something off afterwards.
Post #1491014
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse