15.10 - Configure Execution Time Frames - Query Scheduler

Teradata Query Scheduler Administrator Guide

prodname
Query Scheduler
vrm_release
15.10
category
User Guide
featnum
B035-2511-035K

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.