Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Monday, March 16, 2015 7:55 AM
Points: 85, Visits: 398
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: Wednesday, November 30, 2016 1:03 PM
Points: 243, Visits: 3,037
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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 12:47 PM
Points: 560, Visits: 1,304
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