Share via

  • Article

New Shared Schedule (Management Studio)

Use this page to create a shared schedule to run published reports and subscriptions. Shared schedules can be used in place of report-specific or subscription-specific schedules. Centralized schedule information and the ability to pause and resume scheduled operations are two key features that distinguish shared schedules from item-specific schedules.

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, right-click Shared Schedule, and select New Schedule. To save the schedule, SQL Server Agent service must be running.

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
    Type a name for the shared schedule. This name appears in drop-down lists when users select a shared schedule for reports and subscriptions. Be sure to provide a descriptive name that fits easily within a list and that easily distinguishes one shared schedule from another. A name must contain at least one alphanumeric character. It can also include spaces and some symbols. Do not use the following characters when specifying a name:

    ; ? : @ & = + , $ / * < >

    " /

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

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

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

  • Hour (Recurrence Pattern)
    Select options to run 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)
    Select options to run 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)
    Select options to run 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)
    Select options to run 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
    Select this option to create a schedule that runs only once, on a specific date and time.