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