I want to run a job every 3 seconds. But in SQL Server 2008 we cannot define less than 10 seconds.

I want to run a job every 3 seconds, however in SQL Server 2008 we cannot define an interval of less than 10 seconds.

The job is used to insert/update visitor information, and segmentation information into a database which is tracked by google search.

There are up to about 100 rows inserted in a 2 or 3 seconds. That job inserts and update the table in a database. Is there any way to schedule it using sp job scheduling configuration?

I want to run a job for every 3 seconds. But in SQL Server 2008 we can not set less than 10 seconds.

I want to run a job every 3 seconds. But in SQL Server 2008 we cannot define less than 10 seconds.