Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SSRS 2008 Report Subscriptions

Answered SSRS 2008 Report Subscriptions

  • Friday, January 18, 2013 6:03 PM
     
     
    Sign In to Vote
    0

    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.  

    thanks 

     

All Replies

  • Friday, January 18, 2013 7:01 PM
     
     
    Sign In to Vote
    0


    Did you tried using Stop this schedule on  option?

    • Edited by Sachi_SG Friday, January 18, 2013 7:01 PM
    • Proposed As Answer by Sachi_SG Friday, January 18, 2013 7:02 PM
    • Unproposed As Answer by luizinyo Friday, January 18, 2013 9:31 PM
    •  
     
  • Friday, January 18, 2013 7:47 PM
     
     
    Sign In to Vote
    0
    It doesn't show me a time when i can stop it on just a day
     
  • Monday, January 21, 2013 7:24 AM
    Moderator
     
     Answered
    Sign In to Vote
    2

    Hello,

    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:


    Regards,
    Fanny Liu

    Fanny Liu
    TechNet Community Support