Export (0) Print
Expand All

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 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 Features Supported by the Editions of SQL Server 2012 (http://go.microsoft.com/fwlink/?linkid=232473).

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.

Community Additions

ADD
Show:
© 2014 Microsoft