Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.8 - User Guide

About Backing Up/Restoring with LiteSpeed LiteSpeed User Interface Configure LiteSpeed for First Use Cloud Back Up Databases Automate Maintenance Tasks Restore Databases Restore Objects View Activity and History Use Command-Line Interface Use Extended Stored Procedures Troubleshoot LiteSpeed Review Additional Resources

Define Alerts

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

  1. In the Alerts page, click New to add a new alert.
  2. 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:

    • Database—Select a database to associate with the alert.
    • Error number—Select an error to associate with the alert.
    • Severity—Select this option to raise an alert for a particular event and select a severity code.
    • Raise alert when message contains—Select this option and enter message text to trigger an alert if a message contains that text.

    Performance condition alert definition

    Specify the following options for SQL Server performance condition alerts:

    • Object—Select an object to monitor.
    • Counter—Select an activity counter to monitor the object.
    • Alert if counter—Select a condition to trigger the alert.
    • Value—Enter a threshold value.
    WMI Event Alert

    Specify the following options for alerts raised when a specific SQL Server event occurs:

    • WMI namespace—Specify the WMI namespace for the WMI Query Language statement.
    • Query—Specify the WMI Query Language statement that identifies which WMI event will trigger this alert.
  3. 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.

  4. 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.

 

Related Topics

About Managing Jobs

Create Jobs

About Describing Job Steps

Setting a Job Schedule

Set End-of-Job Actions

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating