Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Alerts

Author  Topic 

amex45
Starting Member

16 Posts

Posted - 2002-06-17 : 15:23:15
?

Edited by - amex45 on 06/17/2002 16:16:08

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-06-17 : 16:11:54
quote:

How to define the response to an alert (Enterprise Manager)
To define the response to an alert

In the details pane, right-click an alert, click Properties, and then click the Response tab.
On the Response tab, select Execute job, and then click a job to execute when the alert occurs.
You can also modify an existing job or create a new job by clicking browse (...).

Under Operators to notify, select E-mail, Pager, or Net send for one or more operators.
Be sure that each operator’s notification method is valid.

Select Include alert error text in with the notification method used if you want the alert error text to be sent with the notification.
Under Additional notifications to send to operator, enter additional information for the operator. The maximum number of characters is 512.
-SQL Server 7, Books OnLine


You could invoke the .exe from the job and set the job as the response to the alert....

<O>
Go to Top of Page
   

- Advertisement -