SQL Server Performance

Scheduling once an hour for part of a day

Discussion in 'SQL Server Reporting Services' started by MattiasT, Oct 12, 2004.

  1. MattiasT New Member

    Hi!

    I wonder if it is possible in any way to schedule reports to run every hour
    each day between 0800 and 1700?

    /Mattias


    /Mattias
  2. satya Moderator

  3. MattiasT New Member

    Here is the answer. Thank you Daniel Reib in the MSDN reportingsvcs newsgroup.

    RS does not natively support this. You could modify the Sql Agent job that
    is associated with the report. The only problem with doing that is that
    everytime the ReportServer service starts it will set the schedule back to
    it's original state. If you don't want the service to reset the schedules,
    set the IsSchedulingService element in the RSReportServer.config file to
    false. However, setting this element will mean RS never checks to ensure
    that your schedules are in sync and they could get changed by any admin of
    SQL.

    /Mattias

Share This Page