[不是问题] sql server agent的重要性 [英] [Not a question] Importance of sql server agent
问题描述
为什么开发人员需要sql server agent
Why Developers need sql server agent
推荐答案
http://www.mssqltips.com/sql-server-tip-category/27/sql-server-agent/ [ ^ ]
简单的谷歌搜索可以为您的问题提供数千个答案。
A simple Google search can give you thousands of answer for your question.
SQL Server代理是一种Microsoft Windows服务，它执行计划的管理任务，在SQL Server 2012中称为作业。
SQL Server代理使用SQL Server存储工作信息。作业包含一个或多个作业步骤。每个步骤都包含自己的任务，例如，备份数据库。
SQL Server代理可以按计划运行作业，以响应特定事件，或者一经请求。例如，如果要在工作日后的几个小时内备份所有公司服务器，则可以自动执行此任务。安排备份在周一至周五22:00之后运行;如果备份遇到问题，SQL Server代理可以记录事件并通知您。
SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs in SQL Server 2012.
SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database.
SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand. For example, if you want to back up all the company servers every weekday after hours, you can automate this task. Schedule the backup to run after 22:00 Monday through Friday; if the backup encounters a problem, SQL Server Agent can record the event and notify you.
SQL Server Agent是Microsoft SQL Server的一个组件，用于调度作业和处理其他自动化任务。它作为Windows服务运行，因此可以在系统引导时自动启动，也可以手动启动。它是。
执行的典型系统任务包括安排维护计划（例如备份），处理Reporting Services订阅和执行日志传送子任务（备份，复制，恢复） & check）。用户任务，例如安排一些T-SQL或命令行语句也很常见。
SQLAgent支持运营商和警报，以便管理员可以得到通知，例如通过电子邮件。
SQL Server Agent is a component of Microsoft SQL Server which schedules jobs and handles other automated tasks. It runs as a Windows service so can start automatically when the system boots or it can be started manually. It is .
Typical system tasks performed include scheduling maintenance plans (such as backups), handling Reporting Services subscriptions and performing log shipping sub-tasks (backup, copy, restore & check). User tasks, such as scheduling some T-SQL or command line statement are also common.
SQLAgent has support for operators and alerts, so that administrators can be notified, e.g. by email.
如果您想自动执行某些SQL服务器任务，请查看SQL Server代理。有了它，您可以安排工作，重新启动服务，发送电子邮件警报以及执行其他自动化。
If you'd like to automate some of your SQL server tasks, check out SQL Server Agent. With it you can schedule jobs, restart services, send email alerts, and perform other automation.
how-to-use-sql-server-agent / [ ^ ]
请参考http://technet.microsoft.com/en-us/library/ms189237.aspx [ ^ ]
这篇关于[不是问题] sql server agent的重要性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
