Process to setup Alerts

Below is the process for setting up Alerts:

Let us take an use case to understand how to set up an alert.

Example

Alert Use case

Compare two schemas, create an alert if the total count of the tables are not matching.

Alert SQL Query

select (case when ColA=ColB then 0 else 1 end ) "AlertValue" 

from (select (SELECT count(oetableid) Lev1 FROM oetable where oeschemaid in (

select oeschemaid from oeschema where schemaname='dbo' AND connectioninfoid =1013)) ColA,

(SELECT count(oetableid) Lev2 FROM oetable where oeschemaid in (

select oeschemaid from oeschema where schemaname='dbo' and connectioninfoid =1014)) ColB) A

Execute and Catalog Query

1. Select the Query editor and Run the above Query.
2. Select the executed query from 'Historic Queries' and save the query with a query name.
   
   
   
   
3. Go to the Alert application to create an alert on the saved query.   
   
   

Creating a data alert

To create a data alert, 

1. Select the Advanced Tools module from the object browser and click the Alerts feature.
2. Click the icon on the top of the screen.
3. Enter an Alert name to identify the alert.
4. Enter the Dataset name(Query name) that has an alert SQL.
   
   
5. Enter a help text, subject, and alert definition to know the details of this alert.
   
   Note: Users can use the @ symbol to add references to a data object in the help text, subject and messages.
   
   
6. Enter the Message of what action is to be taken when the alert is generated.
7. Click Validate and Save the alert.
8. Select the alert saved and assign the users to receive a notification to act.
   
   

Create a job workflow

To create a new job workflow on alerts:

1. Click the Job workflow module from the object browser.
2. Select on the Job workflow information page to create a new workflow job template.     
3. Select Type and choose the Job(s) to be added in the workflow. 
4. Drag and drop the Jobs in the workflow space.
5. When you have completed configuring the workflow template, Enter a Job flow name.
6. Select   to Save the workflow.                                                                     
   
   
   
    
   
   
7.   Close the Workflow space to return to the Job information page of the newly saved template.

You can review the saved workflow to execute, edit, add permissions, notifications, schedule, delete, or view completed jobs and build a workflow template later.

Schedule the Alert

Only administrators can schedule an alert to be run periodically,

1. Navigate the Administration → Job workflow module.
2. Select and choose the type as Alert.
3. All the alert names will be displayed.
4. Drag and drop the specific alert on to the workflow designer.
5. Give a name for the workflow and save. Click the Run button to execute the alert right away.
   
   
   
   

    A notification is sent to the assigned user on successful completion of the job.