Re: Alerts on data values

Michael Chambers wrote:
>
> I am interested in raising alerts or alarms on data in Oracle databases
> which is outside user defined thresholds. The threshold may be a simple
> value or may be derived from a SQL query e.g. trend analysis. The
> alarms may be periodic or triggered by an event (e.g. specified data
> being loaded). The alarms may be raised in a variety of formats e.g.
> email.
>
> I am looking into a number of products including Oracle Alert - note I
> am not running Oracle Applications. I'd appreciate any feedback on such
> products or dealing with similar requirements.
>
> Thanking you in advance,
>
> Mike Chambers

One way would be to write some Pl/SQL blocks that apply the thresholds when new data is inserted and alert the user (perhaps via entries in a table)

Regards,

Mark

-- 
Mark Robbins
All views and comments expressed above,
are my own and not necessarily those of my employer.
mark.robbins.nospam_at_ntc.nokia.com
Remove .nospam to get my real email address.