User's Guide

Setting a Date Range and Time

The upper left portion of the DB2 Query Patroller Recurring Query Scheduler window contains a panel of push buttons for setting the date range and time. This panel contains three sets of push buttons: one for setting the first date the query should run, one for setting the last date the query should run, and one for setting the time of day the query should start. The date range is in the format of month, day, and year. The time push buttons are in the format of hour, minute, and an a.m. or p.m. designator. These push buttons are illustrated below:

To set a date and time for a recurring query, perform the following steps:

1. In the Range: From section, click the left and right mouse push buttons to set the first month, day, and year on which the query should begin running. Clicking the left mouse push button increments the number displayed on a push button. Clicking past the last day in a month increments the month value to the next month. Clicking the right mouse push button decrements the number displayed on a push button. Clicking past the first day in a month decrements the month value to the previous month.

   Note:

   The default date is the current date. Queries scheduled before the current date are immediately submitted for processing.

2. In the Range: To section, click the left and right mouse push buttons to set the last month, day, and year on which the query should run.

   Note:

   This date must be equal to or greater than the Range: From date. The default value is 12/31/2010.

3. From the Create Time section, click the left and right mouse push buttons to set the hours and minutes at which the query should start running. The a.m. or p.m. designator is set automatically.

[ DB2 List of Books | Search the DB2 Books ]