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

Tchater maintenant avec le support

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

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

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
Résolution

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.

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Produit(s) :: Archive Manager
5.10, 5.9.6, 5.9.5, 5.9.4, 5.9.3, 5.9.1, 5.8

Historique de l’article :: Créé le : 12/30/2022
Dernière mise à jour le : 12/19/2025

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