- P21 - Third Party App
- P21 - Data
- P21 - EDI
- P21 - Project
- P21 - Process Issues
- P21 - Dynachange
- P21 - Forms
- P21 - Performance
- P21 - Report/Portal
- P21 - General
- Unassigned
Trouble Shooting when P21 Alerts are Not Firing
In SQL Server Management studio, run the first two statements to determine if anything is queued up or pending.
select count(*) from alert_queued_mail
select count(*) from pending_alerts
Run it twice to ensure nothing is queueing at the same time.
If either statement returns a non-zero value, it is necessary to clear out the table.
Send the following two statements to the DBA, to have them execute in the database instance with the issues.
delete from alert_queued_mail
delete from pending_alerts