Edit

Schedule properties (General page)

  • Article

Use the Reporting Services page in SQL Server Management Studio 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's being used, all currently processing reports and subscriptions triggered from that schedule are 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. These schedules should specify a Friday run date, with one having a start time of 12:00 P.M. and the other 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:

  1. Start SQL Server Management Studio.
  2. Connect to a report server.
  3. Expand the Shared Schedules folder.
  4. Right-click a shared schedule, and select Properties.

Note

This feature is not available in every edition of SQL Server and this page does not appear when you are running an edition which does not have this feature. For a list of features that are supported by the editions of SQL Server, see Editions and supported features of SQL Server 2022.

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.

Related content

Report Server in Management Studio F1 Help
Connect to a report server in Management Studio
Create, modify, and delete schedules
Schedules