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

Chatee ahora con Soporte

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

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

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

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

Product defect
Resolución

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.

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

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

Historial del artículo:: Creado el: 12/30/2022
Última actualización: 12/19/2025

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