If you do not add an alert and the job fails, it is noted in the Windows Application event log, but no one is notified.
To define an alert
Select whether to generate an alert based on an error/event or a performance threshold. Review the following for additional information:
Alert Type | Alert Options |
---|---|
SQL Server event alert description |
Specify the following options for SQL Server event alerts:
|
Performance condition alert definition |
Specify the following options for SQL Server performance condition alerts:
|
WMI Event Alert |
Specify the following options for alerts raised when a specific SQL Server event occurs:
|
Click Response. Select the Execute job checkbox to run the job when an alert occurs.
Select operators to notify. For more information, see Add Operators. about adding a new operator.
Click Options and review the following for additional information:
Include alert error text in |
Select whether to include the text associated with the error in the email, Net send, or pager notification message. |
Delay between responses |
Specify the number of minutes and seconds to wait before sending an additional notification. This is useful if an event occurs more than once and you want to know that the event occurred, but not receive a notification for the additional events related to the alert. |
© ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center