在blog上看到有提出可用alert發送email並加上附檔, 於是到Oracle網站搜尋, 有找到方法, 但Oracle稱只是提供方法, 不提供問題排除及支援.
作法如下:
1. While defining Oracle alert Action, Select 'Action Level' as 'Summary'.
2. In Action Details, select 'Action Type' as 'Operating System Script'.
3. Select the 'Text' radio button.
4. Write the following code : uuencode <Name of the file along with the path> <Name of the attachment in the mail>|mailx -c &cc_mail_id,&to_mail_id -s "<Subject of the Mailer>" &to_mail_id.
5. One can use mail or sendmail command also instead of mailx command.
6. Save Alert details and test.
2. In Action Details, select 'Action Type' as 'Operating System Script'.
3. Select the 'Text' radio button.
4. Write the following code : uuencode <Name of the file along with the path> <Name of the attachment in the mail>|mailx -c &cc_mail_id,&to_mail_id -s "<Subject of the Mailer>" &to_mail_id.
5. One can use mail or sendmail command also instead of mailx command.
6. Save Alert details and test.
Ref:
1.1.ALERTS Interview Questions and Answers in Oracle Apps
http://appselangovan.blogspot.com/2013/10/alerts-interview-questions-and-answers.html
http://appselangovan.blogspot.com/2013/10/alerts-interview-questions-and-answers.html
2.How to Send Email Attachments With Oracle Alerts? (Doc ID 1576621.1)
沒有留言:
張貼留言
注意：只有此網誌的成員可以留言。