Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Operations
Administration (Database Engine)
Administration: How-to Topics (Database Engine)
Automated Administration How-to Topics (SQL Server Management Studio)
How to: Set the Service Startup Account for SQL Server Agent (SQL Server Configuration Manager)
How to: Restart the SQL Server Agent Service (SQL Server Management Studio)
How to: Set the Mail Profile for SQL Server Agent (SQL Server Management Studio)
How to: Set the SQL Server Connection (SQL Server Management Studio)
How to: Set a SQL Server Alias (SQL Server Management Studio)
How to: Configure a User to Create and Manage SQL Server Agent Jobs (SQL Server Management Studio)
How to: Create a Job (SQL Server Management Studio)
How to: Disable or Enable a Job (SQL Server Management Studio)
How to: Create a Job Category (SQL Server Management Studio)
How to: Delete a Job Category (SQL Server Management Studio)
How to: Assign a Job to a Job Category (SQL Server Management Studio)
How to: Change the Membership of a Job Category (SQL Server Management Studio)
How to: Give Others Ownership of a Job (SQL Server Management Studio)
How to: Create a CmdExec Job Step (SQL Server Management Studio)
How to: Create a Transact-SQL Job Step (SQL Server Management Studio)
How to: Define Transact-SQL Job Step Options (SQL Server Management Studio)
How to: Create a PowerShell Script Job Step (SQL Server Management Studio)
How to: Create an ActiveX Script Job Step (SQL Server Management Studio)
How to: Create an Analysis Services Job Step (SQL Server Management Studio)
How to: Set Job Step Success or Failure Flow (SQL Server Management Studio)
How to: View Job Step Information (SQL Server Management Studio)
How to: Set Up the Job History Log (SQL Server Management Studio)
How to: View the Job History (SQL Server Management Studio)
How to: Make a Master Server (SQL Server Management Studio)
How to: Make a Target Server (SQL Server Management Studio)
How to: Enlist a Target Server to a Master Server (SQL Server Management Studio)
How to: Defect a Target Server from a Master Server (SQL Server Management Studio)
How to: Defect Multiple Target Servers from a Master Server (SQL Server Management Studio)
How to: Create a Schedule (SQL Server Management Studio)
How to: Schedule a Job (SQL Server Management Studio)
How to: Set CPU Idle Time and Duration (SQL Server Management Studio)
How to: Notify an Operator of Job Status (SQL Server Management Studio)
How to: Write the Job Status to the Windows Application Log (SQL Server Management Studio)
How to: Automatically Delete a Job (SQL Server Management Studio)
How to: Set the Polling Interval for Target Servers (SQL Server Management Studio)
How to: Start a Job (SQL Server Management Studio)
How to: Stop a Job (SQL Server Management Studio)
How to: View Job Activity (SQL Server Management Studio)
How to: Force a Target Server to Poll the Master Server (SQL Server Management Studio)
How to: View a Job (SQL Server Management Studio)
How to: Resize the Job History Log (SQL Server Management Studio)
How to: Clear the Job History Log (SQL Server Management Studio)
How to: Modify a Job (SQL Server Management Studio)
How to: Modify the Target Servers for a Job (SQL Server Management Studio)
How to: Specify a Target Server's Location (SQL Server Management Studio)
How to: Delete Jobs (SQL Server Management Studio)
How to: Synchronize Target Server Clocks (SQL Server Management Studio)
How to: Script Jobs Using Transact-SQL (SQL Server Management Studio)
How to: Create an Operator (SQL Server Management Studio)
How to: Assign Alerts to an Operator (SQL Server Management Studio)
How to: Format Pager Addresses (SQL Server Management Studio)
How to: Designate a Fail-Safe Operator (SQL Server Management Studio)
How to: Create an Alert Using an Error Number (SQL Server Management Studio)
How to: Create an Alert Using Severity Level (SQL Server Management Studio)
How to: Create a WMI Event Alert (SQL Server Management Studio)
How to: Define the Response to an Alert (SQL Server Management Studio)
How to: Disable or Reactivate an Alert (SQL Server Management Studio)
How to: Designate an Events Forwarding Server (SQL Server Management Studio)
How to: View Information About an Operator (SQL Server Management Studio)
How to: Edit an Operator (SQL Server Management Studio)
How to: Change an Operator's Availability (SQL Server Management Studio)
How to: Delete an Operator (SQL Server Management Studio)
How to: View Information About an Alert (SQL Server Management Studio)
How to: Edit an Alert (SQL Server Management Studio)
How to: Delete an Alert (SQL Server Management Studio)
How to: Script Operators Using Transact-SQL (SQL Server Management Studio)
How to: Script Alerts Using Transact-SQL (SQL Server Management Studio)
How to: Set Job Execution Shutdown (SQL Server Management Studio)
How to: Autostart SQL Server Agent (SQL Server Management Studio)
How to: Send SQL Server Agent Error Messages (SQL Server Management Studio)
How to: View SQL Server Agent Error Log (SQL Server Management Studio)
How to: Rename a SQL Server Agent Error Log (SQL Server Management Studio)
How to: Write Execution Trace Messages to the SQL Server Agent Error Log (SQL Server Management Studio)
How to: Create a Proxy (SQL Server Management Studio)
How to: Modify a Proxy (SQL Server Management Studio)
How to: Delete a Proxy (SQL Server Management Studio)
How to: Script a Proxy Using Transact-SQL (SQL Server Management Studio)
Expand Minimize
This topic has not yet been rated - Rate this topic

How to: Disable or Reactivate an Alert (SQL Server Management Studio)

This topic describes how to disable or reactivate a Microsoft SQL Server Agent alert.

To disable or reactivate an alert

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Expand SQL Server Agent.

  3. Expand Alerts. Right-click an alert and select Enable or Disable.

    The Disable Alert or Enable Alert dialog box displays showing the status of the process.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.