How Are Scheduled Requests Processed? - Query Scheduler

Teradata Query Scheduler User Guide

Product
Query Scheduler
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
the1488824663377.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2512
Product Category
Teradata Tools and Utilities

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: