SQL 作业每 10 秒以内发生一次
是否可以制定作业计划，每少于 10 秒发生一次？ 因为Sql服务器不允许这样做。 计划类型为“重复”并“每日”发生。
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".
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
选择每天发生并每 10 秒运行一次。尽管请记住，如果您的作业花费的时间比指定的运行时间长，代理将不会再次调用它，直到正在运行的任务完成。
请参阅下面的评论。 UI 工具不允许输入时间少于 10 秒。在您的情况下，您可以安排两个偏移一定秒数的作业任务。那么问题是作业可能重叠，因为据 SQL 代理所知，它们是不同的任务。
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 Server 作业），但是我发现唯一可靠的方法是自定义 Windows 服务执行 SQL 语句。
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.