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.
- end_time
- [Optional] Lists all jobs that finished earlier than the specified time.
- last_hour
- [Optional] Lists all jobs that finished in the last X hours, where X is the number of hours.
- 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.
- 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.
- status_mode
- [Optional] Lists all jobs with the status mode specified in the following table.
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