Friday, January 18, 2013 6:03 PM
Hello i have an issue i am faced with which i would like some assistance with, i have a report in SSRS which has to be emailed out every 15 minutes from 8am - 9pm Mon-Sunday. RIght now i have it set to go out every 15 minutes from 8am but i manually turn it off at 9pm every night and set it back for the following day. Is there any way i can set the subscription and it running without me having to manually turn it off each night? Any ideas will be greatly welcomed and appreciated.
Friday, January 18, 2013 7:01 PM
Did you tried using Stop this schedule on option?
Friday, January 18, 2013 7:47 PMIt doesn't show me a time when i can stop it on just a day
Monday, January 21, 2013 7:24 AMModerator
Scheduled report processing uses SQL Server Agent by default. When we create a schedule, the report server also creates a SQL Server Agent job that is used to trigger the schedule.
As per my knowledge, there is not “End Time” in Schedule page in Report Manger. To work around this issue, you can specify the schedule in Job Schedule properties in SQL Server Agent.
Please refer to the following screen shot:
TechNet Community Support