for scheduler job we used @Scheduled at method level like below.
@scheduled(fixedRateString = 120)
public void performUpdate(){
}
Since I am also using the multi POD deployment it will cause RACE condition I guess because from each POD, same request will go to each POD & perform SQL update & delete operations.