Home Forums Reporting Services Reporting Services How to schedule SSRS Report RE: How to schedule SSRS Report

  • January 31, 2013 at 3:02 pm

    #1583206

    The most straight forward way would be to create 12 schedules.

    Schedule 1

    Daily: Monday,Tuesday

    Start 6:00 AM

    Schedule 2

    Daily: Monday,Tuesday

    Start 7:00 AM

    ...

    Or you could try to manipulate the schedule for the SQL job. When you create a scheduled report, it creates a SQL Job that triggers the report. Find the specific SQL job and update the schedule to Recurring > Weekly > Mon, Tue > Occurs every: 1 Hour > Starting at 6:00 AM > Ending at 6:00 PM.