Use Teradata SQL Assistant (a Windows ODBC application) to submit SQL requests to a Teradata Database. When a Teradata SQL Assistant query is rejected by the Teradata Database because of Teradata Dynamic Workload Manager (DWM) rules (Teradata DWM statuses 3149-3159), your DBA can make the Teradata Query Scheduler Submit Request dialog box available so the request can be rescheduled.
To learn how to set up this option, see “Enabling Scheduling of Rejected Teradata SQL Assistant Queries” on page 63. For more information about DWM rules, see Teradata Dynamic Workload Manager User Guide (B035‑2513).
Complete the following steps for your query to automatically be scheduled using Teradata SQL Assistant:
1 Make sure the Teradata QS client software is installed on your system.
2 Use the Teradata QS Administrator to make sure the Scheduled Requests feature is enabled.
3 Make sure at least one Teradata QS server is running.
4 Make sure the request is not always restricted (24 hours a day, 7 days a week).
5 Use the Teradata QS Administrator to make sure the scheduled requests profile allows scheduling.
If the above steps have been taken, the Teradata Query Scheduler Submit Request dialog box will automatically open when a Teradata SQL Assistant request is rejected because of DWM rules.