Personally I have worked in a hospital setting for two years now. First on an inpatient oncology floor and currently as an Emergency Department RN. I was just offered a school nursing position this past week. I guess I am one of the lucky ones since I will be working through an Agency and Agency RNs make more money than RNs directly hired into the school district. My experience with hospital nursing is one of tremendous stress, on your feet 12hrs/day, no time to eat or go to the bathroom. In addition in my case, the lack of adequate staffing made for unbearable conditions and at times put patients at risk safety wise. I am very much looking forward to beginning this new chapter in my career. You can't beat the hours or the time off with all the holidays and summers off. It is nice for me because for the last 8 months I have been working weekend program 12 hour shifts Sat/Sun with only one weekend off per quarter. I also pick up a 12 during the week. It has been exhausting and I spent the entire summer unable to attend many family functions d/t being on the weekend program.
As far as the grass is greener theory, I went from the oncology floor to the ED thinking it would be better....it wasn't. Management is always an issue but I think that school nursing may be different. Since I will be the only RN in my school, I don't have to worry about being understaffed and it appears that the district RN Supervisors are available and more than willing to assist new RNs in this career. I wish you the best of luck.