To run Teradata QS on a new installation of the Teradata Database (that is, one on
which an earlier version of Teradata QS or Teradata DQM has not been installed), run
the tqssetup.bteq script. The script creates scheduling tables in the TDWM database that Teradata QS
uses to store scheduling information.
1
Locate the tqssetup.bteq file.
Note: The default location is C:\Program Files\Teradata\Teradata Query Scheduler Admin 15.10.
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 15.10.
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:
“Configure the Scheduled Requests” on page 37
“Configure Execution Time Frames” on page 38
“Manage Results File Storage” on page 42
“Set Up Workgroups” on page 40
“Manage Scheduler Profiles” on page 44
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.