Good deal!
After Columbine occured in Colorado, the local PD my wife worked at back in Colorado started deploying an officer at each of the city's schools. Having a school resource officer at each school with a marked patrol car parked prominently out front seemed to be a good deterrant for a lot of different types potential trouble. And her PD rotated regular police officers into them. Not just some old, end of their career officers.