What Are Scheduled Requests? - Query Scheduler

Teradata Query Scheduler User Guide

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

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 Chapter 4: “Scheduling Requests.”