To Find out the Workflow Mailer component status

To Find out the Workflow Mailer component status from DATABASE using sqlplus



select COMPONENT_NAME , STARTUP_MODE, COMPONENT_STATUS

from fnd_svc_components where concurrent_queue_id in (select concurrent_queue_id from fnd_concurrent_queues where concurrent_queue_name like 'WF%')

order by COMPONENT_TYPE, COMPONENT_ID