Hi! I have a job in the DA which doesn´t stop running, even if I set it's status to Inactive. I have read that a possible solution is to kill the process that is running the job, is this correct? and if so, how can I do it? Thanks in advance!
Hi,
Probably your process is already stopped/killed and then the properties for the job object are not updated.
To reset the 'running' state clean the correct properties of the dm_job object with DQL:
update dm_job object
set r_lock_owner = ''
set r_lock_date = date('NULLDATE')
set r_lock_machine = ''
set a_special_app = ''
set a_current_status = 'COMPLETED'
where object_name = '<Your job name>'
Best regards,
A. Bos
Yes it is better to kill the Job.
command is from API:
kill,c,<r_object_id of job>
Maybe only it seems that it's running. DA displays "Running" status for a job, if the dm_job object's a_special_app field is set to 'dm_agent_exec'. Last time we had the same issue, it was caused by our mistake: we have checked the "Use this method as Workflow method" for the Method artifact in Composer. Don't run methods in jobs which are checked as workflow methods...
