This is not to mention that having an Agent job run a job every 5 seconds would be a foolish thing to do when considering other aspects of the system. The calls Agent makes to msdb would bloat your plan cache to no end with only running a job every 15 seconds
This is a good point, I didn't give any thought to it and that it would become an issue - thanks much for pointing it out 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience