we have a scenario where User role is changes we have to update Account field then Account's trigger will update 5 related objects so their triggers also fire :) . Earlier we have used process builder at Account level but we are hitting CPU limit so we are switching to Asynchronous (via trigger) .
As I am going through the cheat sheet and understood that if I am modifying a child record and in the same time my Account is getting updated from User trigger it will get locked. so my trigger update may failed because it is already locked.
So is there only one way I can live batch at non working hours? and asking users to wait for the update till tomorrow :(