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.
Would you mind posing your window command in tSystem component here?
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"
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables