'sql server agent job frequency set to 3 seconds
I would like to setup a SQL Server agent job to run every 3 seconds, but I found that the minimum frequency is 10 seconds.
Then I try to setup multiple schedules, such that first schedule starts at 00:00 (run every 10 seconds), second schedule starts at 00:03 (run every 10 seconds), third schedule starts at 00:06 (run every 10 seconds).
But the second schedule and third schedule never runs, I have googled that the sql server agent job needs 5 seconds idle time before the next schedule starts
Is there any idea how I can set the sql server agent job to run in every 3 seconds?
Thanks.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
