how to kill Data services second instance of the job

[Former Member]

Hi All,

is there a way to kill automatically the second instance of the job which has been kicked off accidentally or scheduled to run ?

we have a situation - job needs to be killed if its kicked while first instance of the job is running .

Thanks 

[Former Member · Accepted solution]

Hi Surya,

The best way is make a control table with job_name and it's run status. Add a script in job that whenever job starts execution the status will be set to 1 in the control table and after successful execution of job status will set back to 0 again. And before job starts execution it will check for the run status in that control table and if it's 1 then that means a instance of a job is already running, So if it's already running don't execute the job.

Regards,

Gokul

[Former Member · Accepted solution]

Thank a lot for your reply , let me try.

[Former Member · Accepted solution]

created a job and tested, its working fine. Thanks again.

[Former Member]

Great.!!! Please close the thread.

[Former Member]

You could use a conditional to check that there's only one instance of the job running (perhaps by checking the repository tables/views), and if so then the job started manually or scheduled would quit automatically. We use something similar to schedule a second instance of a particular job in case the first one fails, and when it runs the second time checks the repository table to see if the first one finished, has errors, or is still running and then acts accordingly.

[Former Member]

Why do you need to kill the job? Better stop the execution of second job until the first one is completed successfully. Add a script after the dataflow of first job to capture the job execution status of first job. Check this