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, August 27, 2014 1:18 PM
Points: 83, Visits: 364
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 @ 4:19 AM
Points: 243, Visits: 2,686
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: 2 days ago @ 2:26 PM
Points: 278, Visits: 806
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