IBM Books

User's Guide


Removing a Recurring Scheduled Query

In addition to scheduling a new query, the Query Scheduler allows you to remove an existing recurring query.

Removing a Query for a Specific Day in the Perpetual Calendar

To remove a scheduled query for a specific day in the calendar, perform the following steps:

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

  2. If necessary, open the saved query schedule as explained in Opening an Existing Schedule for a Recurring Query.

  3. 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.

  4. If more than one query is scheduled to run, click the scheduled time that you want to remove in the Selected Times panel.

  5. 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.

Removing a Recurring Query Scheduled to Run for All Days in a Date Range

To remove a query scheduled to run at a specific time for all days in a given date range, perform the following steps:

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

  2. 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.

  3. Click Day.

  4. 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.

  5. Click <<Remove.

    The recurring query is removed from the schedule and the schedule gauges no longer appear.

Removing a Weekly Recurring Query

To remove a recurring weekly query, perform the following steps:

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

  2. 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.

  3. Click the Weekly Queries push button containing the schedule gauge.

  4. 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.

  5. Click <<Remove.

    The scheduled weekly query is removed from the calendar and the schedule gauges no longer appear.

Removing a Recurring Monthly Query

To remove a monthly recurring query, perform the following steps:

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

  2. 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.

  3. On the Monthly page, click the day containing the schedule gauge.

  4. 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.

  5. Click <<Remove.

    The scheduled monthly query is removed from the calendar and the schedule gauge no longer appears.

Removing a Recurring Query Scheduled to Run on the Last Day of the Month

To remove a scheduled query from the last day of the month, perform the following steps:

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

  2. 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.

  3. On the Last of Month page, click the Last push button.

  4. 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.

  5. Click <<Remove.

    The scheduled query is removed from the calendar and the schedule gauges no longer appear.

Viewing a Report of Scheduled Queries

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:


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]