Tickets older than 90days will be Auto-Archived. Ticket updates or comments will reset the timer.

Business Intelligence

Unassigned

P21 - Third Party App

Other Third Party App

IT - Technology

IT - P21

Accounts Payable

Credit Card "PO" Purchases

DGI Forms

Canada Requests

Payroll

Direct Deposit Change

Print...

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

alerts troubleshooting p21

Creation date: 7/25/2024 10:29 AM Updated: 7/25/2024 10:29 AM