SQL Server Performance Forum – Threads Archive

Scheduling once an hour for part of a day

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

http://www.developer.com/db/article.php/3323401 HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

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

]]>