Table of Contents

Search

  1. About the Data Vault Administrator Guide
  2. Introduction to the Data Vault
  3. Data Vault Service Startup and Shutdown
  4. Data Vault Configuration
  5. Data Vault SSL Setup
  6. Data Vault ODBC Setup
  7. Data Vault Administration
  8. Data Repartitioning
  9. Partial Data Vault Copy
  10. Archived Data Migration
  11. Bulk File Uploader
  12. Data Vault Administration Tool
  13. Data Vault Logs
  14. User Account Privileges
  15. ssasql Command Line Program
  16. Data Vault Audit Log
  17. Sample Configuration Files

Data Vault Administrator Guide

Data Vault Administrator Guide

Displaying Task State

Displaying Task State

The Tasks command displays information about the tasks that are queued for execution or are currently being executed by Data Vault Agent processes:
Tasks
The following table describes information that is displayed for each task:
Information
Description
Task
The internal task ID.
Query
The query ID for the task. This query ID can be used in the Cancel command to terminate the query.
File
The unique file ID for the file currently being acted upon by the task, if applicable. This file ID can be specified with the Files command to view information about the file.
Command
The command line used to execute each Data Vault Agent task. Note that all passwords are concealed.
State
The state of the task. It is either Wait (queued for execution) or the host name and AID of the Data Vault Agent process executing the task.
Waiting Time
The total amount of time the task has been queued for execution, if it is not running.
Running Time
The total amount of time that the task has been running, if it is not queued for execution.
Fetched
The total number of rows fetched by a query so far.
Pref Hosts
The preferred host for task execution. This means that Agent processes on this machine will be preferred over other Agent processes for executing the task. The task will be executed by an Agent process on another machine only if all the Agents on the preferred host are busy. Host preference is set with the SetPref command.

0 COMMENTS

We’d like to hear from you!