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)

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

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

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

Product defect
Lösung

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 übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: Archive Manager
5.10, 5.9.6, 5.9.5, 5.9.4, 5.9.3, 5.9.1, 5.8

Artikelhistorie:: Erstellt am: 12/30/2022
Letzte Aktualisierung am: 12/19/2025

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