15.10 - What Can I Do with Teradata QS? - Query Scheduler

Teradata Query Scheduler Administrator Guide

prodname
Query Scheduler
vrm_release
15.10
category
User Guide
featnum
B035-2511-035K

The Teradata QS Administrator is a Windows-based GUI (graphical user interface) that allows the DBA to set up and manage these Teradata QS features:

  • Enable or disable scheduled requests.
  • Create, delete, or modify time periods (called execution time frames) when scheduled requests are executed by Teradata QS.
  • Create, delete, or modify workgroups that equitably distribute resources and scheduled requests workloads during execution time frames.
  • Create, delete, or modify the locations where scheduled request results files are stored and accessed by all Teradata QS servers.
  • Create, delete, or modify sets of scheduled request attributes (called profiles) for users, accounts, DBS roles, and DBS profiles.
  • View, execute, cancel, immediately submit, abort, delete, or modify scheduled SQL requests and jobs to avoid adversely affecting a Teradata Database during prime usage periods.
  • View Teradata QS scheduled request server status.
  • Configure the behavior of scheduled requests using profiles.
  • See Chapter 5: “Use the Teradata QS Administrator” to learn how to use these features. For detailed descriptions of the controls in this interface, see Chapter 3: “Navigate Teradata QS Administrator.”

    Teradata QS has a view-only mode that allows users to log on without being an administrator. In view-only mode, the user can view Teradata QS settings, but cannot make changes. For more information on logging on in view-only mode, see “Open the Teradata Query Scheduler Administrator” on page 35. For a detailed description of the functionality of Teradata QS in view-only mode, see “View-Only Mode” on page 51.