This content has been marked as final. Show 3 replies
I tried the solution detailed in following Metalink Note but still alert did not fire.
*Periodic Alert does not Run at Scheduled Time, Runs when Periodic Alert Scheduler Runs [ID 1016672.102]*
did your query returned any rows ( the one on which the alert is based).
try to submit a concurrent programs ( 'Active Users') as an action for this alert.
Please try to schedule a seeded alert( Oracle Diagnostics) and change the frequency see if it works , if the seeded one also dont work raise a SR with Oracle
Yes, the query returned 1 row.
The alerts are firing now. It seems we are supposed to wait for a day before system will pick newly created periodic alerts.
Using below query(found in Metalink 427965.1) I came to know that all the alerts I created yesterday(20-Nov-2012) are scheduled to be checked the next day.
WHERE alert_name = 'XXMG_PERIODIC_NOTIF_3';
Above query returned 21-Nov-2012 for all periodic alerts I created on 20-Nov-2012.
On 21-Nov-2012 "Periodic Alert Scheduler" picked all the alerts and scheduled them to run as expected. The next_scheduled_check is set to 22-Nov-2012 for all of them now.
So to summarize I can manually test periodic alert by going to Request -> Check where it will pick the "Start Time" as mentioned in alert definition but I can't expect Oracle to schedule the alert on same day of alert creation.
It is bit strange that this important piece of advise is nowhere mentioned in Oracle Alert's User Guide. :-( or may be I am unable to locate it.