Erman Arslan's Oracle Forum
›
EBS 12.2
Login
Register
Search
everywhere
only in this topic
Advanced Search
stop start Workflow mailer by script
Classic
List
Threaded
♦
♦
Locked
2 messages
Options
Loading...
Subscribe via email
Move topic
Pin topic
Unpin topic
Lock topic
Unlock topic
Delete this topic
Delete this topic
Change title and meta tags
Embed post
Permalink
big
Reply
|
Threaded
Open this post in threaded view
♦
♦
|
More
Loading...
Reply to author
Edit post
Move post
Delete this post
Delete this post and replies
Change post date
Print post
Permalink
Raw mail
Jun 06, 2023; 3:07pm
stop start Workflow mailer by script
442 posts
Hi,
On e-business 11.5.10 DB 11.2.04 on AIX
I want to stop start Workflow mailer by the following script. But:
If it is already started , the script stops it without starting.
If it is stopped it starts it.
Any idea?
Here is my script:
#!/bin/sh -u
sqlplus -s apps/mypwd << EOF
spool /u/logs/SC_stop_WF_$USER.log
whenever sqlerror exit sql.sqlcode;
set echo off
--set heading off
declare
p_retcode number;
p_errbuf varchar2(100);
m_mailerid fnd_svc_components.component_id%TYPE;
begin
fnd_svc_component.stop_component(10006, p_retcode, p_errbuf);
commit;
fnd_svc_component.start_component(10006, p_retcode, p_errbuf);
commit;
end;
/
spool off
exit;
EOF
Thank you.
ErmanArslansOracleBlog
Reply
|
Threaded
Open this post in threaded view
♦
♦
|
More
Loading...
Reply to author
Edit post
Move post
Delete this post
Delete this post and replies
Change post date
Print post
Permalink
Raw mail
Jun 07, 2023; 3:13pm
Re: stop start Workflow mailer by script
Administrator
5727 posts
What do you see in the spool/log?
Check the following link as well (note that, I didn't test it) ->
https://ittutorial.org/oracle-workflow-mailer-service-component-auto-restart-crontab
Free forum by Nabble
Edit this page