End-users can submit queries to the Teradata Database using Teradata SQL Assistant (SQLA). When an SQLA-submitted query is rejected because of Teradata Database management rules, a status of 3149 or 3150 is returned to SQLA. The Teradata Query Scheduler Submit dialog box can be specified to appear so the end-user can schedule the rejected query to run at a later time.
If this option is not set up, the end-user does not have the opportunity to schedule the query using the Teradata Query Scheduler Submit dialog box.
1 From the Teradata Query Scheduler Operations window, click Configuration > Client.
The Client Parameters dialog box appears.
2 Select the Display the ‘Query Scheduler - Submit’ dialog for SQL Assistant queries rejected by Teradata Workload Management check box.
3 Continue with “Setting a Response Timeout” on page 64 or click OK to close the Client Parameters dialog box and return to the Teradata Query Scheduler Operations tool.
Now when a Teradata SQL Assistant query is rejected because of Teradata Database management rules, the Teradata Query Scheduler Submit dialog box appears so the user can schedule the query to run at a later time.
Note: Query scheduling for rejected Teradata SQL Assistant queries is subject to the same requirements for scheduling any query.