|
|
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.
|
Locked
