16.20 - Connecting to a Teradata QS Server - Query Scheduler

Teradata Query Scheduler User Guide

prodname
Query Scheduler
vrm_release
16.10
16.20
created_date
May 2017
category
User Guide
featnum
B035-2512-086K

Before scheduling SQL requests using the Teradata Query Scheduler Viewer, connect to a Teradata QS server.

  1. Click Command > Connect or click .

    The Teradata Query Scheduler Connect dialog box appears.

  2. Complete the options as follows:
    Control/Option Description
    Database Name Enter the name of the Teradata Database to use for scheduled SQL requests.
    User Name Enter your user name associated with the Teradata Database entered in the Database Name box.
    Password Enter the password associated with the user name entered in the User Name box.
    Default Database [Optional] Usually, the DBA sets up a default database associated with your user name and password. However, the name of another database can be entered as the default database.
    Account String [Optional] Usually, the DBA sets up a logon account string associated with your user name and password. However, a different account string can be entered instead of using the default.
    Mechanism Select the appropriate authentication mechanism (for example, TD2) in this list box. The default is blank, representing the standard Teradata (TD2) mechanism.
    Parameter Type the authentication string to be used with the mechanism specified. If the specified mechanism does not require this string, leave this option empty.
    Server Displays the name of the Teradata QS server (read-only).
  3. Click OK.

    Teradata QS validates the Teradata Database logon parameters and attempts to obtain information about active Teradata QS servers using a CLIv2 connection.

    If an active server is found, a connection is established.

    If a CLIv2 error occurs, Teradata QS attempts to establish a connection using the Teradata QS server name configured with the Teradata QS Operations tool. See Managing the Teradata QS Server for details on configuring the Teradata QS server.

    If this is unsuccessful, the Server box becomes available. Continue with step 4.

  4. [Optional] Enter the name or IP address of the system the Teradata QS server is running on in the Server box.

    The parameters are validated and the Teradata Query Scheduler Viewer opens.

    If the Teradata QS server has not been started, a message appears stating the following:

    There are currently no Scheduled Requests Servers active.

After opening the Teradata Query Scheduler Viewer and connecting to a Teradata QS server, it is ready for use. See Scheduling Requests to learn about scheduling SQL requests.

See Navigating the Teradata Query Scheduler Viewer to find out about the GUI. To find out how to set up the Teradata Query Scheduler Viewer, go to Customizing the Teradata Query Scheduler Viewer.

At any time disconnect and then reconnect as the same user or a different user. See Disconnecting from a Teradata QS Server and Exiting Teradata QS to learn how to disconnect.