'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