Workflow Mailer Script to check service status

 
sqlplus apps/apps_pwd 

Note: Number of running processes should be greater than 0


 
select running_processes
from apps.fnd_concurrent_queues
where concurrent_queue_name = 'WFMLRSVC';