使用alert对象通过sql server2008中的作业通知操作员的步骤是什么？ [英] what are the steps to notify an operator by a job in sql server2008 using alert object ?

问题描述

我创建了一个工作，之后我创建了一个警报和一个操作员并配置了它们但是之后在运行这项工作时，操作员没有得到基于警报和工作的通知。

我想知道上述问题的原因可能是什么？





问候

Praveen Sinha。

Hi,

I have created a job and after that i have created an alert and an operator both and configured them but after running the job, operator is not getting the notification which was based on alert and job.
I want to know what could be the different reasons for the above problems ?


Regards
Praveen Sinha.

推荐答案

按照此处的说明进行设置运营商：

如何：创建一个运算符（SQL Server Management Studio） [ ^ ]



要通知opperator工作失败，请按照以下说明操作：

如何：通知操作员作业状态（SQ） L服务器管理工​​作室） [ ^ ]



为此，您需要设置数据库电子邮件并配置代理以使用它。请查看以下内容：

数据库邮件配置向导 [ ^ ]

如何：配置SQL Server代理邮件以使用数据库邮件（SQL Server Management Studio） [ ^ ]



希望这有帮助。

Follow the directions here to setup an operator:
How to: Create an Operator (SQL Server Management Studio)[^]

To notify an opperator of a job failure, follow these directions here:
How to: Notify an Operator of Job Status (SQL Server Management Studio)[^]

For this to work, you will need to setup your database email and configure the agent to use it. Check out the following:
Database Mail Configuration Wizard[^]
How to: Configure SQL Server Agent Mail to Use Database Mail (SQL Server Management Studio)[^]

Hope this helps.

这篇关于使用alert对象通过sql server2008中的作业通知操作员的步骤是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！