locked
SSRS 2008 Report Subscriptions RRS feed

  • Question

  • 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 

    Friday, January 18, 2013 6:03 PM

Answers

  • 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

    • Proposed as answer by Fanny Liu Wednesday, January 23, 2013 1:17 AM
    • Marked as answer by Fanny Liu Friday, January 25, 2013 5:02 AM
    Monday, January 21, 2013 7:24 AM

All replies


  • 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:01 PM
  • It doesn't show me a time when i can stop it on just a day
    Friday, January 18, 2013 7:47 PM
  • 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

    • Proposed as answer by Fanny Liu Wednesday, January 23, 2013 1:17 AM
    • Marked as answer by Fanny Liu Friday, January 25, 2013 5:02 AM
    Monday, January 21, 2013 7:24 AM