Data Driven Subscriptions
The example below illustrates how to create a data driven subscription in four easy steps.
The T-SQL code stores a SSRS report on a file share and send off an email notification.
The sample is applicable for any version of MS SQL Server (2000 or higher) and the Boomerang framework (Standard Edition or higher).
The four steps are as follows:
1. Create Event
2. Create Job
3. Add content to Job
4. Release Event
The sample code includes comments in-line.
For more information please visit: http://www.fuel9.com/home/content/Data-Driven-Subscriptions