If he can get things running again, I expect he will stay at USU for a long time given his failures at Wisconsin and Oregon State. He has a reputation as a great recruiter and could do some great things again in Logan.
However if he can't beat his alleged demons (coeds and booze per twitter) he could drive the Aggies back into the ground like he did with Oregon State.
I'm rather surprised USU backed off of more national options like Rich Rod or Todd Orlando given Andersen's recent failures.