Enterprise Alert provides the functionality for users to switch their personal alerts on or off. If the alerts are switched off, the user will no longer receive alert notifications.
This functionality might be useful during vacations or when there is a temporary alert flood you would like to pause for a while.
As an administrator, you might want to switch back on the alerts for all users in order to make sure all users can again receive alert notifications. You can do this in the Enterprise Alert database with the following SQL statement:
UPDATE [EnterpriseAlert2016].[dbo].[MMPROFILES] SET [PROFSTATUS] = [PROFSTATUS] & ~2;
After that the alerts will be switched on again for all users.
That is it ….