Schedule Recommendation - Teradata Index Wizard

Index Wizard allows you to schedule when an index recommendation is applied to the production database. This feature uses Teradata Query Scheduler to schedule requests.

Note: The schedule recommendation feature only works with Teradata Query Scheduler 15.00 and above. If Creation > Schedule Recommendations is dimmed, Teradata Query Scheduler might not be installed or properly set up. For more information, refer to the Teradata Query Scheduler Administrator Guide.

1 Click Creation > Schedule Recommendations.

The Select Recommendations dialog box appears.

2 Fill in the dialog box as follows.

Dialog Box Option	Description
QCD Name	Enter the QCD name or click to display a list.
Workload Name	Enter the name of the Workload or click to display the list of workloads in the QCD.
Index Tag	Select an Index tag.
Table Name	Indicates the table name where the recommendation must be executed.
Statement Text	Displays the DDL text of the index recommendations, as well as COLLECT/DROP STATISTICS statements.
Select All	Selects all the recommendations.
Deselect All	Deselects all the recommendations.

3 Select the recommendation to be executed, and click Next.

The Schedule Recommendations dialog box appears.

4 Fill in the dialog box as follows.

Option	Description
Scheduling Options	Specifies the parameters for scheduling the recommendations.
Request Name	Type a name for the request.
User ID	Indicates the User ID on which the Teradata Query Scheduler session was created. This is the same as the current user ID specified at logon.
Start Date	Specify the date when the recommendations is to be executed.
Start Time	Specify the time when the execution of the recommendations begins.
Maximum Wait Time	Specify the maximum time up to which the start of execution can be deferred if an execution window is not available at the specified time.

5 Click Schedule to schedule the recommendation at the specified date and time.

6 A message appears with the Request Id number and Job Id number. Make note of these numbers, and click OK.

7 To view your request, open the Teradata Query Scheduler Viewer. Look in the list for your Request Id and Job Id numbers.

Note: If you receive an error, see “Schedule Recommendation Errors” on page 132.