SQL Job Occurring every Less than 10 seconds

Is it possible to make Job Schedule, which will occur every less t开发者_如何学Pythonhan 10 seconds? Because Sql server doesn't allow that. Schedule type is "Recurring" and Occurs "Daily".

Select occurs Daily and run every 10 seconds. Although keep in mind if your job takes longer than the time specified to run, the agent won't invoke it again until the running task completes.

See comments below. The UI tool doesn't allow input for less than 10 seconds. In your case you could schedule two job tasks offset by some number of seconds. The issue then is that the jobs could overlap as they are distinct tasks as far as SQL Agent knows.

I tried do something similar (SQL Server job with prcise timing), but the only reliabile way I found was custom windows service execution SQL statements.