Determining WF Java Mailer availability without using Oracle Application Manager

The Workflow Java Mailer status can be checked on table FND_SVC_COMPONENTS. The column “component_status” tells the status of the different Service Components

This table holds just a few rows and the component for the Java Mailer is called 'Workflow Notification Mailer' with component id 10006.

This table can be queried up any time using Cron jobs. So whenever the mailer is detected down, A mail can be sent to the administrator who can log in and restart the mailer.
SQL statement to query the status of the workflow mailer

SQL> select COMPONENT_ID,COMPONENT_STATUS from FND_SVC_COMPONENTS where COMPONENT_ID=10006;

COMPONENT_ID COMPONENT_STATUS
------------ ----------------------------------------------
10006 DEACTIVATED_SYSTEM