Running the tqssetup.bteq script - 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
  1. Locate the tqssetup.bteq file.
    The default location is C:\Program Files (x86)\Teradata\Client\16.00\Bin
  2. Open the tqssetup.bteq file in a text editor.
  3. In the .logon statement, replace dbsName with the name of the Teradata Database whose tables you are upgrading to 16.00.
  4. Save the file and exit the text editor.
  5. Execute the script using BTEQ. See Basic Teradata Query Reference (B035-2414) for instructions. After the tqssetup.bteq script has completed processing:
    • From the Query Scheduler Administrator main window, enable scheduling, configure time frames, file storage, workgroups, and profiles. See:
    • Using Query Scheduler Operations, configure Client and Server parameters. In particular, on the Server Parameters screen, fill in the Database Logon information so that Teradata QS communicates with the correct Teradata Database.
    • Restart the Operations utility if prompted to do so, and then restart the server. After the server has started, in the Scheduler Viewer (client) application, use the Connect command to connect to a Teradata QS Server, and the Schedule SQL command to submit scheduled requests.