当创建并计划 SQL Server 代理作业时,我们应该第一次开始手动运行该作业还是自动启动
我创建了一个 Sql Server 代理作业并安排它每 10 分钟运行一次。 第一次运行时,我们是否需要在按计划时间开始之前手动运行一次作业。基本上,作业第一次运行是如何进行的。
此外,当创建作业时,作业的所有者处于禁用状态。这会影响工作安排吗?
I have created a Sql Server agent job and scheduled it to run every 10 mins.
For the first time, when it runs should we need to run the job manually once before it starts with scheduled time. Basically how does the job run for the first time.
Also when the job is created the owner of the job is in disabled state. will this effect the schedule of the job?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
该作业将按照您提供的计划运行 - 无需手动运行它来“启动”计划。
禁用的作业永远不会按计划执行 - 计划的执行将被跳过。它们仍然可以手动执行。
如果您希望通过计划触发已禁用的作业,则必须先启用它。
The job will run on the schedule you provide - there is no need to run it manually to "prime" the schedule.
Disabled jobs are never executed by schedule - the scheduled executions will be skipped. They can still be executed manually.
If you have a disabled job which you wish to be triggered by a schedule, you must enable it first.