Query Report Server Database for next run date of subscriptions

• Sarah 38992

  SSC Eights!

  Points: 825

  More actions

  August 9, 2010 at 7:39 am

  #387529

  Hi

  Can anyone tell me how to identfy which reports are due to run today/next from the ReportServer database?

  I have a query that looks at the Subscriptions and the Schedule tables but am having trouble find the appropriate column for the actual schedule or next run time/date.

  Thanks

• Sarah 38992

  SSC Eights!

  Points: 825

  More actions

  August 9, 2010 at 8:11 am

  #1204184

  I've found a solution on a previous post

  http://www.sqlservercentral.com/Forums/Topic957724-1063-1.aspx