What
are Oracle Alerts?
Oracle Alerts are used
to monitor unusual or critical activity within a designated database. The
flexibility of ALERTS allows a database administrator the ability to monitor
activities from table space sizing to activities associated with particular
applications (i.e. AP, GL, FA). Alerts can be created to monitor a process in
the database and to notify a specific individual of the status of the process.
There are 2 types of
Alerts: Event Alerts and Periodic Alerts.
a) EVENT ALERTS are triggered when an event or change is made to a table in the database.
b) PERIODIC ALERTS are activated on a scheduled basis to monitor database activities or changes.
a) EVENT ALERTS are triggered when an event or change is made to a table in the database.
b) PERIODIC ALERTS are activated on a scheduled basis to monitor database activities or changes.
When an alert is
executed, the alert can send an email message, run a concurrent program, run an
operating system script, or run a
SQL statement script. Using response processing, Oracle Alerts can solicit a response from a specific individual and perform an action
based on the response that it receives.
SQL statement script. Using response processing, Oracle Alerts can solicit a response from a specific individual and perform an action
based on the response that it receives.
Event or Periodic Alerts
can work with any custom application, as long as the application is properly
registered within Oracle
Applications.
Applications.
Which Email packages
work with Alerts?
Since 11i.RUP4, all
email is routed through Workflow Mailer.
Can Alerts be triggered
using other Tools? (i.e. other than Oracle Forms or concurrent programs)
Oracle Event Alerts can
only be triggered from an application that has been registered in Oracle
Applications. Alerts cannot
be triggered via SQL updates or deletes to a table.
be triggered via SQL updates or deletes to a table.
What is Response
Processing?
Response processing is a
component of Alerts which allows the recipients of an alert to reply with a
message and have the
applications take some action based on the response.
applications take some action based on the response.
Do I need Oracle
Applications to use Alerts?
Yes. Oracle Applications
is required to create and run Alerts using Alert Manager Responsibility.
No comments:
Post a Comment