I designed an alert for one of my requirement, for this i build i a sql statement
and my sql statement is returning 20 records and i check the same in Application, the records are matching and till now every thing works fine for me.
When i start my alert, My alert is firing 20 times and i am receiving 20 mails, but my requirement is i need to consolidated all the records and need to send a mail.
Do i need to do some setup for this, please help me on this.
Thanks for all for your continuous help and guidance.
When you created your alert action to create the notification, what did you set the action level to? Sound like you want it to be Summary but you have it set at Detail. Create another notification at Summary level and see if you get the results you are looking for.