Workflow Mailer Script to check mailer status

Workflow Mailer Script to check mailer status

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

March 27, 2014 В· Sanjay В· No Comments
Posted in: 3. All Scripts, 8. Workflow Mailer

Leave a Reply

You must be logged in to post a comment.