Scheduling Hourly Report between predefined hours

Hi everyone,

I'm using 2005 Reporting Services and trying to schedule an hourly report to be sent out between 8:00am and 8:pm. Am I doing something wrong or does SSRS really not support end time? Do I have to create 12 seperate jobs?

Any help would greatly be appreciated.

Thanks,

- gshaf

The RS scheduling does not support this. You can work around this, but it does have consequences. If you create a schedule you can then go into SQL Agent and modify the corresponding schedule to fire when you would like. The problem is that RS will reset the schedule every 12 hours. :) To stop RS from doing this, go into RSReportServer.config file and set IsSchedulingService to false. By doing this RS will not verify that the schedule data it has matches what SQL Agent has. If you view the schedule via Report Manager it will show the old schedule, not the modified SQL Agent schedule, and of course if you change it via Report Manager it will modify the SQL Agent job as well.

I hope that helps.

|||

Thanks very much... perhaps it's worth a shot.

- gshaf