16.20 - What Are Scheduled Requests? - Query Scheduler

Teradata Query Scheduler User Guide

prodname
Query Scheduler
vrm_release
16.10
16.20
created_date
May 2017
category
User Guide
featnum
B035-2512-086K
Scheduled requests are SQL queries submitted to a Teradata Database that become scheduled for off-line execution. Schedule requests in the following two ways:
  • Using the Teradata Query Scheduler Submit Request dialog box
  • Using Teradata SQL Assistant

When existing database rules prevent your SQL request from running or if your queries will overload your database, proactively schedule your request using the Teradata Query Scheduler Submit Request dialog box.

When a request is scheduled, provide information that defines preferences for when it is executed. A request can be scheduled to run periodically or only once during a specified time period without an active user connection to the Teradata Database.

Because a scheduled request can be executed many times, the term request is used to mean the actual definition of the scheduled request parameters. The term job is used to mean an individual instance a scheduled request is scheduled to run.

For example, define a scheduled request to execute daily. That request causes a separate job to be created every day to execute that request.

Your DBA can enable or disable the Teradata QS features of your Teradata Database using the Teradata QS Administrator. For details, see Teradata Query Scheduler Administrator Guide (B035-2511).

To learn about how to schedule a request, see Scheduling Requests.