Geek asks and answers

SQL work done every less than 10 seconds

Can I create a work schedule that will run every less than 10 seconds? Because the Sql server does not allow this. The schedule type is Repeating and appears Daily.

+3
source share
2 answers

The selection occurs daily and starts every 10 seconds. Although keep in mind that if your work takes longer than the start time, the agent will not call it again until the task is completed.

See comments below. The user interface tool does not allow input for less than 10 seconds. In your case, you can schedule two tasks to complete for a certain number of seconds. The problem then is that jobs can overlap because they are different tasks, as far as SQL Agent knows.

SQL Agent

+3
source

I tried to do something similar ( a SQL Server job with scrolling times ), but the only reliable way I found was with custom SQL statements to execute SQL queries.

0
source

More articles:


All Articles