how to kill Data services second instance of the job
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 .
Gokul Gawande replied
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.