User's Guide

Scheduling a Query to Recur Weekly

Use the Weekly page to schedule a query to run on a specific day and week in a month.

The Weekly page contains a weekly queries section that represents each day in the week. This page also contains radio buttons for selecting the time of month the query should be scheduled.

The weekly queries section and radio buttons work together to define when a recurring query will run. For example, if you clicked Mon in the weekly queries section and selected the First in Month radio button, the query is scheduled to run on the first Monday of each month in the date range you have specified. Selecting the Third in Month radio button schedules the query to run on the third Monday of each month in the date range you have specified. You can select any combination of radio buttons. Selecting the All in Month radio button causes all of the other radio buttons to be selected.

To schedule a query to recur weekly, perform the following steps:

1. Access the Recurring Query Scheduler window as explained in Accessing the Recurring Query Scheduler Window.

2. Set the date range for the recurring query. See Setting a Date Range and Time for instructions on setting a date range.

3. Click the Weekly tab.

4. On the Weekly page, select the day of the week you want the query to run.

5. Select the appropriate radio buttons to set the time of month the query will run.

6. Click Add>>>.

   The days that the query is scheduled to run are indicated in the perpetual calendar section by schedule gauges.

[ DB2 List of Books | Search the DB2 Books ]