Workflow Mailer Script to check service status

Posted on by

 
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';