I have created JDBC to RFC scenario. It is working fine. Now, I want to send email alert to destination team when zero data came. Please suggest, how can I acheive this.
If select query doesnt pull anything in sender JDBC communication channel, means zero data extracted from JDBC sender channel, I need to send email alert to destination team.
>>If select query doesnt pull anything in sender JDBC communication channel, means zero data extracted from JDBC sender channel
Yes, but it doesn't mean that anything is sent to PI. When nothing is sent to PI and there are no errors, alerts can't be generated. Can JDBC channel scheduling help you in some way as a workaround?
Instead of using a select query, is it possible to use Stored Procedure? Then in the SP you can check for the records and raise error.
There is one possible option. In the mapping area check using exists node function of the sender mandatory node element and if the exists function return true means data exist and if not then create your target structure as mail receiver and send mail message. So basically you do enhanced interface determination through multimapping without bpm. If the data exists map receiver structure one and if not map the email receiver structure.
Refer this [link |http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90dcc6f4-0829-2d10-b0b2-c892473f1571?QuickLink=index&overridelayout=true]for handling different receivers.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.