Previous  Next          Contents  Index  Navigation  Glossary  Library

The Periodic Alert Scheduler

The Periodic Alert Scheduler (ALEPPE) is a concurrent program that automatically checks your scheduled periodic alerts.

How the Periodic Alert Scheduler Works

The Periodic Alert Scheduler runs at each day at 12 AM. When it runs, the Periodic Alert Scheduler looks for all periodic alerts scheduled to be checked that day, and then submits one concurrent request for each scheduled check.

For example, suppose you have two periodic alerts scheduled to be checked today. You scheduled the first alert for 6 AM, and the second for every two hours between 10 AM and 6 PM. The Periodic Alert Scheduler submits three requests. The first request is for the first alert at 6 AM. The second request is for the second alert at 10 AM, with a resubmission interval of two hours thereafter, and an end time of 6 PM. The last request is for the Periodic Alert Scheduler to run again at 12 AM. Every time Oracle Alert checks an alert successfully, it inserts that day's date in the Last Checked field of the Alerts form.

The Periodic Alert Scheduler also checks for any alerts that were scheduled to run the previous day but failed. It does this by looking for alerts that do not have the date and time of the latest scheduled check in the Last Checked field. The Periodic Scheduler resubmits each failed alert to the concurrent manager every day until the alert runs successfully (that is, the error causing it to fail is corrected) or is disabled.

How Oracle Alert Checks an Alert

Oracle Alert performs each action in an action set in sequence. During an alert check, Oracle Alert checks each action set for any defined input values, then substitutes the input values into the alert Select statement and executes it. Oracle Alert then performs each member of the action set in sequence, substituting the defined output variables with the exception data returned by the Select statement.

If one of the action set members is an escalation group, Oracle Alert determines which action to perform based on that action's defined escalation level. If one of the action set members is a threshold group, Oracle Alert performs either the detail or the summary action, depending upon the summary threshold defined and the number of exceptions returned by the Select statement.

   To activate or deactivate the Periodic Alert Scheduler:

See Also

Creating a Periodic Alert

Action Escalation

Defining a Summary Threshold

         Previous  Next          Contents  Index  Navigation  Glossary  Library