CODEWITHSUNDEEP
sql-server-2005jobsjob-scheduling
scatterbraiin
scatterbraiin

Reputation: 323

SQL Job Occurring every Less than 10 seconds

Is it possible to make Job Schedule, which will occur every less than 10 seconds? Because Sql server doesn't allow that. Schedule type is "Recurring" and Occurs "Daily".

Upvotes: 4

Views: 8423

Answers (2)

TcKs
TcKs

Reputation: 26632

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.

Upvotes: 0

Yuck
Yuck

Reputation: 50835

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.

SQL Agent

Upvotes: 3

Related Questions