Scheduling a task that happens very frequently in Sql Server
I've used SQL Server Agent to run jobs every 10 seconds. It's OK.

If you don't have it, you can use the Windows Scheduler to run osql or sqlcmd as required.
Or say Quartz.net in your app. Or anything that can call a database on a schedule (AutoSys etc)