Process service queue
Emails are handled by the mail agent which uses the service queue to pick up jobs.
Emails are not received
If an mail is not received by an actor, you can use the following command to examine the service queue for mails that failed to generate:
select * from service_queue where agent_type = ‘WZP’ and status = ‘2’;
status = 2 indicates that the mail generation failed and the column status_txt may reveal the cause of the failure.
Run the job again
Clear the following status to run the job again when the problem is resolved:
update service_queue set status = ‘’ where key = <key number>;