SQL 2008 R2 - 基于时间的触发器? [英] SQL 2008 R2 - Time-Based Triggers?

问题描述

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

Is it possible to have a stored procedure or set of SQL code run periodically by specifying a time-based trigger in SQL Server?

推荐答案

不是直接，而是看 SQL工作.

作业是由 SQL Server 代理顺序执行的一系列指定操作.作业可以执行广泛的活动，包括运行 Transact-SQL 脚本、命令行应用程序、Microsoft ActiveX 脚本、Integration Services 包、Analysis Services 命令和查询或复制任务.作业可以运行重复性或可调度的任务，并且它们可以通过生成警报自动通知用户作业状态，从而大大简化 SQL Server 管理.

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 - 基于时间的触发器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！