Configure Execution Time Frames - Query Scheduler

Teradata Query Scheduler Administrator Guide

Product
Query Scheduler
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2511
lifecycle
previous
Product Category
Teradata Tools and Utilities

The DBA controls when scheduled SQL requests are executed on the system by defining and enabling execution time frames. An execution time frame is a period of time in which scheduled SQL requests are permitted to run and when the Teradata QS server will attempt to execute any scheduled requests.

After creating an execution time frame, the DBA must make it available on your Teradata Database system. Scheduled requests are not accepted or run unless an execution time frame is available.

When a user submits a request for scheduling, Teradata QS determines whether there are any execution time frames available during the scheduled time period. If no execution time frames are available and the maximum start interval is exceeded, then the request is not scheduled.

Although multiple execution time frames can be created and enabled, only the primary Teradata QS server dispatches and executes the scheduled requests.