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
See Parameter Order.
- dm.rest.endpoint
- [Optional] Enter a Data Mover REST server URL to overwrite the default value specified in the commandline.properties file in order to connect to a different REST server (and therefore a different daemon) at runtime.
- end_time
- [Optional] Lists all jobs that finished earlier than the specified time.
- freeze_step_only
- [Optional] Lists only jobs with freezeJobSteps=true.
- last_hour
- [Optional] Lists all jobs that finished in the last X hours, where X is the number of hours.
- latest_job_only
- [Optional] Returns the status of the most recent completed job, per job name, after meeting the conditions specified by other parameters.
- start_time
- [Optional] Lists all jobs that started later than the specified time.
- status_mode
- [Optional] Lists all jobs with the status mode specified in the following table.
Status Mode | Description |
---|---|
A | All jobs (default). |
N | All new jobs. |
I | All initializing jobs. |
R | All running jobs. |
C | All successfully completed and completed with warnings jobs. |
F | All failed jobs. |
RS | All restarting jobs. |
Q | All queued jobs. |
B | All blocked jobs due to object locks. |
UC | All user-cancelled jobs. |
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 16.20.25.00 2019-05-13 18:56:22 - List Jobs mode Command parameters: About to connect to REST server at https://localhost:1443/datamover Connected to Daemon version 16.20.25.00 List jobs... Job Name Start End Status Priority ------------------------------------------------------------------------------------------------ jp_high_1 5/13/19 6:50 PM 5/13/19 6:50 PM COMPLETED_SUCCESSFULLY HIGH jp_high_2 5/13/19 6:51 PM 5/13/19 6:51 PM COMPLETED_SUCCESSFULLY HIGH jp_high_3 5/13/19 6:51 PM 5/13/19 6:52 PM COMPLETED_SUCCESSFULLY HIGH jp_high_4 5/13/19 6:52 PM 5/13/19 6:52 PM COMPLETED_SUCCESSFULLY HIGH jp_low_1 5/13/19 6:53 PM 5/13/19 6:53 PM COMPLETED_SUCCESSFULLY LOW jp_low_2 5/13/19 6:54 PM 5/13/19 6:54 PM COMPLETED_SUCCESSFULLY LOW jp_low_3 5/13/19 6:54 PM 5/13/19 6:55 PM COMPLETED_SUCCESSFULLY LOW jp_low_4 5/13/19 6:55 PM 5/13/19 6:55 PM COMPLETED_SUCCESSFULLY LOW