16.20 - How Are Scheduled Requests Processed? - Query Scheduler

Teradata Query Scheduler User Guide

Query Scheduler
May 2017
User Guide

Teradata QS accepts single- or multiple-statement query requests for execution at a later time. However, scheduling a request does not guarantee that it is executed at the specified date and time. Your scheduled requests are subject to the same Teradata Database workload management rule checking as are interactive requests.

In addition, an execution time frame must be available during the time specified to execute the request. Your DBA controls when scheduled requests are executed. Using the Teradata Query Scheduler Administrator, your DBA specifies one or more execution time frames, or time periods, in which scheduled requests are executed by the Teradata QS server. Your DBA must specify active execution time frames. If execution time frames are not defined or enabled, scheduled requests are not executed by Teradata QS.

Scheduled requests are subject to three phases of processing: