A while back, I created a solution to check for any object that ended in FAULT_OTHER in the past 5 mins and to send an email with a list of objects if there are any.
The query in the SQL variables are written for SQL Server, so if you're using Oracle or DB2, they'll need to be rewritten.
Import the .xml and then execute the SCRI.FAULT > Recurring for every 5 mins (Or adjust to a different time frame as needed)
Download Me
(This only works for v9 and later)