Updating the destination e-mail address for an alert policy from SQL Server Management Studio

Chat now with support

Updating the destination e-mail address for an alert policy from SQL Server Management Studio - Archive Manager (4369796)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Updating the destination e-mail address for an alert policy from SQL Server Management Studio - Archive Manager
Description

Due to a product defect, the Alert Service Policies page does not display, thus making it impossible to update an Alert Policy through the user interface.
Cause

Product defect
Resolution

As a workaround, you can make changes to this information via the SQL Server Management Studio (SSMS).

*We strongly recommend creating a backup of the database prior to making any changes. *

Open SSMS and within the Archive Manager database, locate the 'AlertsGlobal' table and run an UPDATE query to modify the contents of the policy you wish to update.

For example:
USE ArchiveManager
UPDATE ArchiveManager.dbo.AlertGlobals
SET "To" = 'new_email@domain.com'
WHERE Alertglobals.AlertId ='####'

Once the data has been updated, restart the 'Archive Manager Alert Service' service for these changes to take effect.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Updating the destination e-mail address for an alert policy from SQL Server Management Studio - Archive Manager (4369796)