Disable the Alert notification in all the tenant without changing the roles and permission

News Knowledge Base
1

How to Modify the Corn expression of the Trigger 'NotificationDistributerJob' in DB?

Issue: How to disable the notification in all the tenant without changing the roles and permission?

Resolution:

  • A "Notification Distributer Job" is a specific workflow designed to distribute notifications to various recipients based on certain conditions or triggers. i.e. Alert email Notification
  • Modify the Corn expression of the Trigger 'NotificationDistributerJob' in DB.

For versions > 22.10.x

  • Disable the Notification

Update [dbo].[SystemJobsSchedules] set Configuration = '{"CronExpression":"* * * * *","Timeout":"00:00:05","MaxRetries":0}' where Name = 'NotificationDistributerJob'

  • Enable the notifications

Update [dbo].[SystemJobsSchedules] set Configuration = '{"CronExpression":"0/10 1/1 * 1/1 * ? *","Timeout":"00:00:05","MaxRetries":0}' where Name = 'NotificationDistributerJob'

For versions < 22.10.x

  • Disable the Notification

Update [quartz].[QRTZ_CRON_TRIGGERS] set CRON_EXPRESSION='* * * * *' where TRIGGER_NAME='NotificationDistributerJob'

  • Enable the notifications

Update [quartz].[QRTZ_CRON_TRIGGERS] set CRON_EXPRESSION='0/10 1/1 * 1/1 * ? *' where TRIGGER_NAME='NotificationDistributerJob