[ALRT] [ALERT MGR] 2 Types of Alert

Periodic

Send email or run OS/SQL script or submit concurrent program once alert was triggered on periodic basis. Means it will triggered by time, e.g. Once a day, Every N day, Every Business Day, etc.

Event

Send email or run OS/SQL script or submit concurrent program once alert was triggered on event basis. This event is referring to database trigger event, it will triggered "After Insert" or "After Update" of a database table.

[ALRT] Event Alert

For Event alert, once you verified and saved it, Oracle will create a database trigger (db object) on the table you specified.

For example,

Table name in the Event alert is PO_ABC.

A database trigger will be created with name ALR_PO_ABC_UAR or ALR_PO_ABC_IAR. UAT denotes "Update After Record", whereas IAR denotes "Insert After Record".

Once Alert is fired, this database trigger will spawn (submit) a concurrent request with name starts with the table name, e.g. PO_ABC (Check Event Alert). The concurrent request will check SQL in Alert to determine whether to perform any action.

[ALRT] Manually Trigger a Alert

How to manually trigger a Alert which has Frequency set as "On Demand"?

Ans: Under Alert Manager responsibility, Request -> Check, enter Application name, Alert name, Start Date and click "Submit Request".