How to check the status/stop/start Workflow Notification Mailer from Backend

We all know the steps on How to check the status/stop/start Workflow Notification Mailer from OAM.

Here I would be telling you about How to check the status/stop/start Workflow Notification Mailer from Backend

First How to check the status of Notification Mailer

a) Check workflow mailer service current status
sqlplus apps/

b) select running_processes
from fnd_concurrent_queues
where concurrent_queue_name = ‘WFMLRSVC’;

Number of running processes should be greater than 0

c) Find current mailer status
sqlplus apps/

select component_status
from fnd_svc_components
where component_id =
(select component_id
from fnd_svc_components
where component_name = ‘Workflow Notification Mailer’);

Possible values:
RUNNING
STARTING
STOPPED_ERROR
DEACTIVATED_USER

 

Now how to stop Notification Mailer from Backend

a) Stop notification mailer
sqlplus apps/

b) declare
p_retcode number;
p_errbuf varchar2(100);
m_mailerid fnd_svc_components.component_id%TYPE;
begin
— Find mailer Id
—————–
select component_id
into m_mailerid
from fnd_svc_components
where component_name = ‘Workflow Notification Mailer’;
————–
— Stop Mailer
————–
fnd_svc_component.stop_component(m_mailerid, p_retcode, p_errbuf);
commit;
end;
/

 

Now how to start Notification Mailer from Backend

a). Start notification mailer
sqlplus apps/

b) declare
p_retcode number;
p_errbuf varchar2(100);
m_mailerid fnd_svc_components.component_id%TYPE;
begin
— Find mailer Id
—————–
select component_id
into m_mailerid
from fnd_svc_components
where component_name = ‘Workflow Notification Mailer’;
————–
— Start Mailer
————–
fnd_svc_component.start_component(m_mailerid, p_retcode, p_errbuf);
commit;
end;
/