Workflow Mailer Script to check mailer status

Posted on April 20, 2019 by Yogi

 
sqlplus apps/apps_pwd

 
select component_status
from apps.fnd_svc_components
where component_id =
(select component_id
from apps.fnd_svc_components
where component_name = 'Workflow Notification Mailer');

Note: Possible values:
RUNNING
STARTING
STOPPED_ERROR
DEACTIVATED_USER
DEACTIVATED_SYSTEM