User's Guide
In addition to scheduling a new query, the Query Scheduler allows you to
remove an existing recurring query.
To remove a scheduled query for a specific day in the calendar, perform the
following steps:
- Access the Recurring Query Scheduler window as explained in Accessing the Recurring Query Scheduler Window.
- If necessary, open the saved query schedule as explained in Opening an Existing Schedule for a Recurring Query.
- Click the day of the month for which you want to delete a query.
The day must display a schedule gauge in order for you to remove a scheduled
query.
- If more than one query is scheduled to run, click the scheduled time that
you want to remove in the Selected Times panel.
- Click <<Remove
The recurring query is removed from the selected day. The scheduled
time for the query is no longer displayed in the Selected Times panel.
To remove a query scheduled to run at a specific time for all days in a given
date range, perform the following steps:
- Access the Recurring Query Scheduler window as explained in Accessing the Recurring Query Scheduler Window.
- Click the Daily tab.
On the Daily page, a schedule gauge displays on the Day push
button. On the calendar, all days in the scheduled date range display
schedule gauges.
- Click Day.
- If more than one query is scheduled to run on this day, select the
scheduled time that you want to remove in the Selected Times panel.
- Click <<Remove.
The recurring query is removed from the schedule and the schedule gauges no
longer appear.
To remove a recurring weekly query, perform the following steps:
- Access the Recurring Query Scheduler window as explained in Accessing the Recurring Query Scheduler Window.
- Click the Weekly tab.
On the Weekly page, a schedule gauge displays on the Weekly
Queries push button and on the corresponding day in the perpetual
calendar.
- Click the Weekly Queries push button containing the schedule
gauge.
- If more than one query is scheduled to run on that day, click the
scheduled time that you want to remove in the Selected Times panel.
- Click <<Remove.
The scheduled weekly query is removed from the calendar and the schedule
gauges no longer appear.
To remove a monthly recurring query, perform the following steps:
- Access the Recurring Query Scheduler window as explained in Accessing the Recurring Query Scheduler Window.
- Click the Monthly tab.
On the Monthly page, a schedule gauge displays on day of the recurring
query. A schedule gauge appears on the corresponding day in the
perpetual calendar.
- On the Monthly page, click the day containing the schedule gauge.
- If more than one query is scheduled to run on that day, click the
scheduled time that you want to remove in the Selected Times panel.
- Click <<Remove.
The scheduled monthly query is removed from the calendar and the schedule
gauge no longer appears.
To remove a scheduled query from the last day of the month, perform the
following steps:
- Access the Recurring Query Scheduler window as explained in Accessing the Recurring Query Scheduler Window.
- Click the Last of Month tab.
On the Last of Month page, a schedule gauge displays on the Last
push button and on the last day of the month in the perpetual calendar.
- On the Last of Month page, click the Last push button.
- If more than one query is scheduled to run on this day, click the
scheduled time that you want to remove in the Selected Times panel.
- Click <<Remove.
The scheduled query is removed from the calendar and the schedule gauges no
longer appear.
To view a report of all scheduled queries in a date range, select Print
Preview from the File drop-down list.
While viewing the report, click one of the following push buttons:
- Print to print the report contents
- Next Page to view the next page in the report (if applicable)
- Prev Page to view the previous page in the report (if
applicable)
- Two Page to view the report in two page format
- Zoom In to enlarge the report view
- Zoom Out to minimize the report view
- Close to return to the DB2 Query Patroller Recurring Query
Scheduler window
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]