Create Periodic Alert and schedule it.
Hope this will help you...
Standard Process -
Use Alert Manager Responsibility to create periodic alerts.
Some useful Link for reference -
Develop Report with required output format and us xml bursting process to send mail alert.
Customize way - Create your own mailing pl/sql package. Lot of sample codes are available. Create your own flexi html format and schedule it using concurrent request scheduler.
Oracle Alert is not firing "on Day of the Week"
In alert manager -->request---> check
when i submit the alert and after completion , the alert is getting fired.
Every sunday i need this to alert to fire
please i need some help