Monitor App Messaging Errors

PeopleSoft provide an application engine program to monitor the error status in application messages. However it involves more setup to schedule this program. It is important to monitor these messages, as No further messages will be processed, if one of them errors out. Here are 3 simple SQL scripts that can be used to Monitor the error Status for messages

Various Status Codes and their descriptions
0 - Error, 1 - New , 2 - Started, 3 - Working,
4 - Done, 5 - Retry, 6 - Timeout, 7 - Edited, 8 - Canceled
Message Instance Script
select * from PSAPMSGPUBHDR WHERE PUBSTATUS IN (0,6);
Publication Contract Script
select * from PSAPMSGPUBCON WHERE PUBCONSTATUS IN (0,6);
Subscription Contract Script
select * from PSAPMSGSUBCON WHERE SUBCONSTATUS IN (0,6);