• Article

Schedule Properties (General Page)

Use this page to view or modify a shared schedule. Shared schedules can be used in place of report-specific or subscription-specific schedules. Changes to the schedule are applied after you save the schedule. Editing a schedule has no effect on jobs that are currently in progress. If you edit a schedule while it is being used, all currently processing reports and subscriptions triggered from that schedule will be allowed to finish.

Not all frequency combinations can be supported in a single schedule. For example, if you want to run a report at 12:00 P.M. and 4:00 P.M. every Friday, you must create two daily schedules that specify a Friday run date, one with a start time of 12:00 P.M. and another with a start time of 4:00 P.M.

Schedule processing is based on the local time of the report server that hosts and processes the schedule.

To open this page, start SQL Server Management Studio, connect to a report server, open the Shared Schedules folder, right-click a shared schedule, and select Properties.

Note

This feature is not supported in SQL Server Express with Advanced Services. The page does not appear when you are running the Express edition.

Options

  • Name
    Specifies the name for the shared schedule.

  • Begin running this schedule on
    Specifies a start date for this schedule.

  • Stop this schedule on
    Specifies an expiration date for this schedule.

  • Type
    Specifies whether the recurrence pattern is based primarily on hours, days, weeks, months, or only runs once.

  • Hour (Recurrence Pattern)
    Specifies options for running a scheduled operation in intervals of an hour (for example, to run a report every 6 hours). You can specify the interval in hours and minutes.

  • Day (Recurrence Pattern)
    Specifies options for running a scheduled operation in intervals of days (for example, to run a report every 2 days). You can specify the interval in days and at the hour and minute you want the schedule to run.

  • Week (Recurrence Pattern)
    Specifies options for running a scheduled operation in intervals of a week or when the pattern that you want to repeat is based on weeks (for example, to run a report every other week). You can specify a weekly schedule to the day, hour, and minute that you want the schedule to run.

  • Month (Recurrence Pattern)
    Specifies options for running a scheduled operation in intervals of a month or when the pattern that you want to repeat is based on months. You can specify a monthly schedule to the day, hour, and minute that you want the schedule to run. You can omit specific months from the schedule.

  • Once
    Specifies a schedule that runs only once, on a specific date and time.