topic Re: How to kill a command initiated using tsystem component in Talend Studio

How to kill a command initiated using tsystem component

Raghunath — Sat, 16 Nov 2024 08:52:36 GMT

Hi,

I am using tSystem component to run a windows command which is runs for 2 hours normally. I need to check output of that command, if output is wrong i need to kill the job along with command.

Even if I kill the job, command will be running in the background. I can see that command process in Task manager.

What I want to implement is -- When ever I kill the job, windows command should be killed in Talend job before job terminates.

Thanks,

Raghunath.

Re: How to kill a command initiated using tsystem component

Anonymous — Thu, 18 Jan 2018 09:32:28 GMT

Hello,

Would you mind posing your window command in tSystem component here?

Best regards

Sabrina

Re: How to kill a command initiated using tsystem component

Raghunath — Thu, 18 Jan 2018 12:16:09 GMT

Hi Sabrina,

Below is my bcp command with context variables and globalMap variables which will be replaced with values at the run time.

"bcp ["+context.vDatabaseName+"].[dbo].["+context.vTableName+"] in "+((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))+" -e "+context.vFileSharePath+((String)globalMap.get("tFileList_1_CURRENT_FILE"))+"_Error.txt -c -t "+context.vDelimiter+" -S "+context.vServerName+" -T -h -m 1"

Thanks,

Raghunath.