适用于:11.5到12
在workflow mailer没有启动之前,邮件队列中有很多等待发送的mail,一旦workflow mailer启动,这些邮件就会发送。如何阻止这些邮件发送?
1.查询哪些通知等待发送邮件
1 SELECT NOTIFICATION_ID, STATUS, MAIL_STATUS, BEGIN_DATE
2 FROM WF_NOTIFICATIONS
3 WHERE STATUS = 'OPEN'
4 AND MAIL_STATUS = 'MAIL';
2.更改这些邮件状态为“已发送”
UPDATE WF_NOTIFICATIONS
SET MAIL_STATUS = 'SENT'
WHERE MAIL_STATUS = 'MAIL';
3.清空队列中的数据(在应用节点运行)
语法格式:
sqlplus usr/passwd@db @$FND_TOP/patch/115/sql/wfntfqup.sql APPSusr APPSpw FNDusr
例如:
sqlplus apps/apps @$FND_TOP/patch/115/sql/wfntfqup.sql apps apps applsys
4.启动workflow mailer