Export (0) Print
Expand All

How to: Create, Delete, or Modify a Shared Schedule (Management Studio)

A shared schedule contains schedule and recurrence information that can be used by any number of published reports and subscriptions that run on a Reporting Services report server. If you have many reports and subscriptions that run at the same time, you can create a shared schedule for those jobs. If you want to subsequently change the recurrence pattern or the end date, you can make the change in one place.

Shared schedules are easier to maintain and give you more flexibility in managing scheduled operations. For example, you can pause and resume shared schedules. Also, if you find that too many scheduled operations are running at the same time, you can create multiple shared schedules that run at different times and then adjust the schedule information until the processing load evens out across the report server.

To create or modify a shared schedule

  1. Start SQL Server Management Studio and connect to a report server instance.

  2. In Object Explorer, expand a report server node.

  3. Right-click the Shared Schedules folder, and then click New Schedule. The General page of the New Shared Schedule dialog box is displayed.

    To modify an existing shared schedule, expand the Shared Schedules folder, right-click the schedule you want to modify, and then click Properties.

  4. Type a descriptive name for the schedule.

  5. Optionally select a date to start the schedule. The default is the current day.

  6. Optionally select a date to end the schedule. The schedule stops running on this date, but is not deleted.

  7. To configure a recurring schedule, select Hour, Day, Week, or Month. Additional options are displayed. Use these additional options to configure schedule frequency, based on your preferred hour, day, week, or month.

    Or, to specify a one-time (non-recurring) schedule, select Once, and then specify a Start time.

  8. Click OK.

To delete a shared schedule

  1. In Object Explorer, expand a report server node.

  2. Expand the Shared Schedules folder, right-click the schedule you want to delete, and then click Delete. The Delete Catalog Items dialog box appears.

  3. Click OK.

If you delete a shared schedule that is used by multiple reports and subscriptions, the report server will create individual schedules for each report and subscription that previously used the shared schedule. Each new individual schedule will contain the date, time, and recurrence pattern that was specified in the shared schedule. Note that Reporting Services does not provide central management of individual schedules. If you delete a shared schedule, you will now have to maintain the schedule information for each individual item. Before deleting a shared schedule, use the Reports Page to determine which reports are currently using the shared schedule.

Community Additions

ADD
Show:
© 2014 Microsoft