list_jobs - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.00
Published
December 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
rdo1467305237457.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

The list_jobs command displays a list of all jobs that have run on the Data Mover daemon with the specified status mode. Job definitions are not displayed.

Parameters

start_time
[Optional] Lists all jobs that started later than the specified time.
The format is: yyyy-MM-dd-HH
2014-02-20-16
start_time cannot be used with last_hour.
end_time
[Optional] Lists all jobs that finished earlier than the specified time.
The format is: yyyy-MM-dd-HH
2014-02-20-16
end_time cannot be used with last_hour.
last_hour
[Optional] Lists all jobs that finished in the last X hours, where X is the number of hours.
The value must be a positive integer.
6
last_hour cannot be used with start_time or end_time.
broker.url
[Optional] You may enter a broker URL to overwrite the default value specified in the commandline.properties file in order to connect to a different ActiveMQ server (and therefore a different daemon) at runtime.
dm-server1
broker.port
[Optional] You may enter a broker port to overwrite the default value specified in the commandline.properties file in order to connect to a different ActiveMQ server (and therefore a different daemon) at runtime.
61616
status_mode
[Optional] Lists all jobs with the status mode specified in the following table.
R
Codes and Descriptions of Status Modes
Status Mode Description
A All new jobs and all jobs that completed successfully. This is the default.
N All new jobs.
I All jobs that are initializing.
R All jobs that are running.
C All jobs that completed successfully.
F All jobs that failed.
RS All jobs that are restarting.
Q All jobs in the job queue.
B All jobs that are blocked due to object locks.

XML File Example

For the list_jobs command, type datamove list_jobs -f parameters.xml.

The following example shows a parameters file, dmListJobs.xml, for the list_jobs command.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dmListJobs xmlns="http://schemas.teradata.com/dataMover/v2009"
xmlns:xsi= "http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://schemas.teradata.com/unity/datamover.xsd">
	<status_mode>C</status_mode> 
</dmListJobs>
Here is an example of the screen output of running the list_jobs command:
Data Mover Command Line 14.10.00.00
List Jobs mode 
Command parameters:
About to connect to ActiveMQ at localhost:61616
Permission authorized
Daemon secuirty is on false
User name null
Connected to Daemon version 14.10.00.00
List jobs...
Job Name     Start             End                Status                  Priority
-----------------------------------------------------------------------------------
jp_high_1    4/25/13 6:11 PM   4/25/13 6:15 PM    COMPLETED_SUCCESSFULLY  HIGH                  
jp_high_2    4/25/13 6:15 PM   4/25/13 6:18 PM    COMPLETED_SUCCESSFULLY  HIGH                  
jp_high_3    4/25/13 6:18 PM   4/25/13 6:23 PM    COMPLETED_SUCCESSFULLY  HIGH                  
jp_high_4    4/25/13 6:20 PM   4/25/13 6:23 PM    COMPLETED_SUCCESSFULLY  HIGH                  
jp_low_1     4/25/13 5:59 PM   4/25/13 6:02 PM    COMPLETED_SUCCESSFULLY  LOW                   
jp_low_2     4/25/13 6:00 PM   4/25/13 6:19 PM    COMPLETED_SUCCESSFULLY  LOW                   
jp_low_3     4/25/13 6:01 PM   4/25/13 6:24 PM    COMPLETED_SUCCESSFULLY  LOW                   
jp_low_4     4/25/13 6:02 PM   4/25/13 6:39 PM    COMPLETED_SUCCESSFULLY  LOW