Job Execution - Query Scheduler

Teradata Query Scheduler Administrator Guide

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

Teradata QS server follows these steps when attempting to run a scheduled request job:

  • Retrieves information about the request from the Teradata QS database.
  • Logs on to the database as the user, with an optional account name.
  • If a results table/file was specified and the results table/file currently exists, the job fails unless the user specified that the results could be deleted.
  • Runs the request.
  • Reschedules the job for at least 15 minutes later if a Teradata Database workload management restriction is encountered.

    When a job needs to be rescheduled, an updated execution time is computed. If the updated time exceeds the start interval for the job, the status of the job is marked as restricted because it will not be completed within its execution time frame.

  • If a results table/file was specified, the last statement of the scheduled request is first run in prepare mode to obtain the column types and names of the result data. If necessary, the result table/file is recreated with those column types, and the last statement (which must be a SELECT statement) is run. The result data is written to the results table/file.