gpt4 book ai didi

SQL 2008 R2 - 基于时间的触发器?

转载 作者:行者123 更新时间:2023-12-04 00:34:55 25 4
gpt4 key购买 nike

是否可以通过在 SQL Server 中指定基于时间的触发器来定期运行存储过程或 SQL 代码集?

最佳答案

不是直接,而是看看 SQL Jobs

A job is a specified series of operations performed sequentially by SQL Server Agent. A job can perform a wide range of activities, including running Transact-SQL scripts, command-line applications, Microsoft ActiveX scripts, Integration Services packages, Analysis Services commands and queries, or Replication tasks. Jobs can run repetitive tasks or those that can be scheduled, and they can automatically notify users of job status by generating alerts, thereby greatly simplifying SQL Server administration.



(强调我的)

关于SQL 2008 R2 - 基于时间的触发器?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/5573002/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com