No Alert To Show In Alerts Page When The Job Has Failed

News Knowledge Base
1

No Alert to show in Alerts page when the job has failed.

Note: Making DB changes should be done with extreme caution. Take a backup before making the recommended changes.

The internal job might stuck in blocking state which could cause this issue. Check the below conditions,

  1. Robot role and make sure the user has the permission to view and create the Alert
  2. Table qrtz_trigger. If the status of notification is 'blocked', need to update the DB by using the following SQL and restart the IIS server.
UPDATE QRTZ_TRIGGERS SET TRIGGER_STATUS = 'WAITING' WHERE TRIGGER_NAME = 'NotificationDistributerJob'