16.20 - Modifying a Scheduled Request or Job - Query Scheduler

Teradata Query Scheduler User Guide

prodname
Query Scheduler
vrm_release
16.10
16.20
created_date
May 2017
category
User Guide
featnum
B035-2512-086K

Use the following procedure to modify the properties for a request or job.

  1. From the Teradata Query Scheduler Viewer, select a job from the Jobs list.
  2. Click Options > Request Properties, or click , or right-click the job to display a shortcut menu and click Request Properties.

    The Teradata Query Scheduler View/Modify Request dialog box appears as read-only with the Request tab selected by default.

  3. Select the Modify parameters to make a new request check box to switch to edit mode.
    The tabs in the Teradata Query Scheduler View/Modify Request dialog box are the same as those in the Teradata QS Submit dialog box.
  4. Use the Request, SQL, Scheduling, or Results tabs to change the properties. See Scheduling a SQL Request to learn how to enter information in these tabs.
  5. Click OK.

    If the new request is submitted successfully, a message box appears with your Request ID number and Job ID number.

  6. Click OK to close the message box.
  7. A message appears prompting to delete the original request. To delete the original request, click Yes. Otherwise, click No.

    If No was selected, your new request appears in the Jobs list of the Teradata Query Scheduler Viewer. Your original request remains in the Jobs list.

    If Yes was selected, another confirmation message appears such as the following:

    This will delete all the jobs associated with the selected request. Are you sure you want to delete request 34840?
  8. To delete the selected request, click Yes. Otherwise, click No.

    If No was selected, your new request appears in the Jobs list of the Teradata Query Scheduler Viewer. Your original request remains in the Jobs list.

    If Yes was selected, another confirmation message appears such as the following:

    Do you want to drop the Results for request 34840?
  9. To drop the results for the request, click Yes. Otherwise, click No.

    If Yes was selected, the results for the request are dropped and your new request appears in the Jobs list.

    If No was selected, the results for the request are not dropped and your new request appears in the Jobs list.