title: SSRS Update Run Time of Schedule from Back End
body: <p>Hello I have about 900+ subscriptions that I would like to update to run at 10 AM instead of 7 AM. I cannot find on the reporting server or in my many google searches what field I need to update.</p>
  
  <p>To get general data I am using the below query. It seems there must be a field somewhere holding the Run Time, probably in XML?</p>
  
  <pre><code>USE reportserver
  GO
  
  select  c.Name,
  s.StartDate,
  s.NextRunTime,
  s.LastRunTime,
  s.EndDate,
  s.RecurrenceType,
  s.LastRunStatus,
  s.MinutesInterval,
  s.DaysInterval,
  s.WeeksInterval,
  s.DaysOfWeek,
  s.DaysOfMonth,
  s.[Month],
  s.MonthlyWeek
  from    dbo.catalog c with (nolock)
  inner join  dbo.ReportSchedule rs
  on  rs.ReportID = c.ItemID
  inner join  dbo.Schedule s with (nolock)
  on  rs.ScheduleID = s.ScheduleID
  where ISNULL(s.ENDDATE,'2050-01-01') &gt;= '2016-01-01'
  order by    c.name
  </code></pre>