Designing a notification routine
Most ETL/ELT tools have a notification mechanism embedded within the product. However, in the solution, you may require notifications at many different places across different products (Shell Scripts, Scheduled Jobs, APEX, OWB, ODI, and so on). For this reason, it may be more beneficial to utilize a custom notification mechanism which can be embedded into multiple processes.
Getting ready
Review the types of notifications which are required within your projects and also from which products. Determine if a standard mechanism exists before building a custom notification routine. If more than one exists, consider building your own custom notification routine.
How to do it...
Notifications can be an easy way to send results. Ensure that the information sent is meaningful and actionable. Refrain from spamming every status:
1. Create Access Contol Lists (ACLs) and privileges. In Oracle 11g, you are required to create an ACL as SYS. Log in as SYS. Create an ACL for...
