Oracle Periodic Alert
Overview : This Alerts are triggered periodically like Hourly, Daily, Weekly, Monthly or On Demand.
We Will Define Periodic Alert which will notify us regarding if any responsibility of user is added/updated.
Steps to Creation of periodic Alert.
Step 1: Define Alert
Navigation: Alert Manager -> Alert -> Define
Define Oracle Alert |
Frequency: Select the frequency from the list of value.
Select Statement: Enter the select statement which fetch all the data required for
Query Should be in Below Format:
Select Columns (:input if needed)
into &output
from Table
Conditions
Save the changes.
Check the SQL statement is successfully parsed in Alert or not using Verify Button.
Step 2: Define Actions in oracle alert
Navigation: Click on Actions Button to define the Actions.
You can define multiple actions for a single Alert.
Define Actions |
Click on Action Details.
Below are the action types which we can define to execute once alert triggered.
- Concurrent Programs - you can call concurrent in oracle alert
- SQL Statement Script
- Message (Mail)
- OS Script
Action Details |
You can use output parameter here.
Step 3: Define Action Sets in oracle alert
Navigation: Click on Action Sets Button.
Here you can define set of actions which you want to execute once alert triggered.
Click on Action Sets Button |
Define Set of Actions |
Define Action Set Details
Click on Action Set Details Button.
Action Set Details window will pop up. You will find the input,output parameter which used in SQL statement.
Input Parameter Details |
Output Parameter Details |
In Members tab you can select the Action which we define in Step 2
Define the Action Name in Action Sets |
Step 4: Define Alert Details
Define the Data Types,Default values, format for input and output parameters.
Define Data Types of Input Parameter |
Same for Output Parameter.
Output Parameters |
You can define the user and operating unit for which you are going to use Alert.
Define User and Operating Unit |
In this way you can define the Periodic Alert. You can check the history of your Alert and also check for any exception occurred or not.
Check the History of Oracle Alert -
You can check history of oracle alert using below navigation.
Navigation: Alert Manager -> History
History of Alert |
Check all the actions,exception,checks of the Alert.
Exception if Any |