New Installation - Query Scheduler

New Installation

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.

To run the tqssetup.bteq script

1 Locate the tqssetup.bteq file.

Note: The default location is C:\Program Files\Teradata\Teradata Query Scheduler Admin 15.00.

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.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:

“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.