About Starting a Blocked Job - 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

The sync parameter of the Start command waits for a job to complete and then returns an exit code to indicate whether the job completed successfully. The effect of the sync parameter setting when trying to start a blocked job is outlined below.

If a blocked job is started and the sync parameter is:
Sync parameter Effect
Enabled The command line waits until the job starts successfully or fails because the maximum retry interval is reached. The job is marked as failed if the locks are not released when the maximum interval is reached or if a daemon failure occurs while it is in a blocked state. Jobs that fail this way can be started again after the locks are released or when the daemon is restored.
Not enabled The command line exits with a message that an attempt to start the job will be made when the locks are released. A background process will attempt to check locks after the interval specified by blocked.job.retry.interval and start the job if no locks are detected. During the time that a job waits for locks to be released, the job is in a blocked state, which is displayed in the Status output. A user can cancel a blocked status job at any time by running the stop command. A job in a blocked state consumes a slot from the maximum concurrent job limit until it runs or fails due to reaching the maximum retry interval.