416.467.9100 | Dundas Data Visualization | Login
Welcome Guest
Dashboard v5.0

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

Setting up a Schedule

Hide navigation
RSS
Modified on Fri, 24 May 2013 04:53 PM
Click to return to: Documentation | Connecting to Data


Overview

This article shows how to use the Define Caching Schedule, Define Import Schedule, or Define Report Schedule dialog to set up a schedule for performing recurring operations, such as:


The Define Caching Schedule dialog.

The Define Caching Schedule dialog.


Note: The Dundas Dashboard Scheduler service ensures that only a single scheduled task will be running at any time on the Dundas Dashboard server. However, in web farm deployment scenarios, where more than one web server will have Dundas Dashboard installed (but sharing the same data store), you should ensure that the Dundas Dashboard Scheduler service is running on only one server computer (and disabled on the other servers).

Setting up a schedule

By default, the Define Import Schedule (or Define Caching Schedule) dialog is configured with a monthly schedule that starts on the current date and the current time of day. A textual summary of the schedule definition is displayed at the top of the dialog and the date and time of the next scheduled operation is also listed. These two fields are automatically updated whenever you make changes to the settings in this dialog.

The summary and next run time for a scheduled operation.

The summary and next run time for a scheduled operation.


To set up a schedule using the Define Import Schedule (or Define Caching Schedule) dialog:

  1. Use the Enabled check box to either enable or disable the schedule. This option lets you temporarily disable a schedule without having to change its definition.
  2. Choose the start date and start time for your schedule:
    • Enter a starting date for your schedule in the Start Date box (or click the calendar icon to select a date by using a date picker).
    • Enter the time of day to begin the scheduled operation in the Start Time box (or click the clock icon to choose a pre-defined time from a menu).
      The start date and time for a schedule.
    • (Optional) Select the Recurrence option if you want the operation to run more than one time on the same scheduled day. Use the resulting Define Schedule Recurrence dialog to specify the times when you want the operation to run.
  3. Specify how you want the schedule to end by choosing one of the following options:
    • To have your schedule run continuously, select the No end date option.
    • If you want the schedule to stop after a specific number of scheduled occurrences have run, select the End after option and type the number of desired occurrences in the box provided.
      Scheduling a one-time occurrence.
    • To have the schedule end by a certain date, select the End by option and type the end date in the box provided (or click the calendar icon to select a date by using a date picker).
  4. Choose one of the following schedule patterns:
  5. Review the Summary and Next run time values, which are displayed at the top of the dialog.
  6. Click OK to complete the definition of the schedule.

Setting a monthly schedule

To set up a monthly schedule pattern:

  1. Select the Monthly option.
  2. Choose the day of the month to run the scheduled operation:
    • To run the scheduled operation on a specific day number of each month, select the Day option and enter the day number in the box provided.
      A schedule that runs on the 15th day of each month.
    • To run the scheduled operation on a specific day of the week for each month:
      • Select the second option.
      • Click the first dropdown list and choose the week of the month (e.g. first week, second week, etc.)
      • Click the second dropdown list and choose the day of the week (e.g. Sunday, Monday, etc.)
  3. Select the months in which the schedule will run. By default, all months are selected.

Setting a weekly schedule

To set up a weekly schedule pattern:

  1. Select the Weekly option.
  2. Specify that the scheduled operation should be run every x number of weeks by entering a value in the box provided.
  3. Select the days of the week to run the scheduled operation. By default, all days of the week are selected.
    A weekly schedule.

Setting a daily schedule

To set up a daily schedule pattern:

  1. Select the Daily option.
  2. Specify that the scheduled operation should be run every x number of days by entering a value in the box provided.
    A daily schedule.

Defining schedule recurrence

The Define Schedule Recurrence dialog lets you specify the times when a scheduled operation should run (on the same scheduled day).

Define Schedule Recurrence dialog.

Define Schedule Recurrence dialog.


As an example, to have the operation run on a regular interval, such as every 30 minutes from 9 a.m. to 12 p.m.:

  1. Select the Every option.
  2. Enter 30 in the numeric up-down box.
  3. Select the Minutes option in the time units dropdown list.
  4. Set the From box to 9:00 AM (or click the clock icon to choose a pre-defined time from a menu).
  5. Set the Until box to 12:00 PM (or click the clock icon to choose a pre-defined time from a menu).
  6. Click OK.

Note: The From time must be earlier than or equal to the Until time. If you try to change the From time to be later than the Until time, the Until time will be automatically updated to match the new From time. Similarly, if you try to change the Until time to be earlier than the From time, the From time will be automatically updated to match the new Until time.

Specify recurrence times using a regular interval.

Specify recurrence times using a regular interval.


Alternatively, to specify the occurrence times directly (e.g. if you have irregular time intervals):

  1. Choose the Selected Times option. The list of existing occurrence times is displayed in a grid.
  2. To add a new occurrence time to the grid, click the Add Time button. Type the new time value directly into the added grid entry, or click the clock icon to choose a pre-defined time from a menu.
  3. To remove an occurrence time from the grid, select the occurrence time, then click the Remove Time button.
  4. Click OK.

Specify recurrence times directly.

Specify recurrence times directly.


Related topics


Click to return to: Documentation | Connecting to Data

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2014 Dundas Data Visualization, Inc.