title: Data Driven SSRS Subscription without SQL Server 2008 R2
body: <p>I am trying to mimic the functionality of a data driven subscription.  We are current running a version of report server that does not allow for Data Driven Subscripts.  Current this is what I am working with</p>
  
  <pre><code>use ReportServer 
  
  declare @datetime varchar(29)
  set @datetime = convert(varchar(16),dateadd(MINUTE,2,GETDATE()), 126) +  ':00.000-05:00'
  
  
  update Subscriptions
  
  set MatchData = '&lt;ScheduleDefinition xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;&lt;StartDateTime xmlns="http://schemas.microsoft.com/sqlserver/2006/03/15/reporting/reportingservices"&gt;' + @datetime + '&lt;/StartDateTime&gt;&lt;/ScheduleDefinition&gt;',
  
  modifieddate = convert(varchar(23),GETDATE(), 121)
  
  where SubscriptionID = '48FB6FE9-969B-4E8D-AD37-E80CE20FDDE5'
  
  
  
  update Schedule
  
  set StartDate = CONVERT(VARCHAR(16), dateadd(minute, 2, GETDATE()), 121) +   ':00.000',
  
  NextRunTime = null
  
  where Name = '3664a678-af17-4a05-9ff4-5666ea727e91'
  </code></pre>
  
  <p>It updates the report server however when the time comes it does not execute.  Does anyone know how I can trigger this?</p>