You can set alerts to be notified by e-mail messaging at the occurance of runtime events such as, when projects or jobs start, complete, or generate an error message. To set these alerts on the engine you are connected to, select Tools | Alert Manager from the ETL Development UI. The Alert and Event Configuration window appears:
Engine pane – select the engine to configure the alert on. By default, the selected engine is the one started by ETL Development.
Events pane – includes a navigation tree that displays different event types:
Jobs – occurs when a job starts, finishes normally, or finishes with errors.
Job Start – occurs when a job starts.
Job Finish – occurs when a job finishes normally.
Job Error – occurs when a job finishes with errors.
Projects – occurs when a project starts, finishes normally, or finishes with errors.
Project Start – occurs when a project starts.
Project Finish – occurs when a project finishes normally.
Project Error – occurs when a project finishes with errors.
Alerts pane – displays event to alert mappings.
Alert Definition pane – used for configuring alerts.
Creating an alert for an event
Select the engine on which you want to configure the alert.
Select the event type.
In the Alerts pane, click the Add icon.
Provide a unique name for the new alert and click OK.
In the Alert Definition pane, specify e-mail preferences and filter conditions for the new alert.
E-mail Preferences:
Enter appropriate values in the “To,” “CC,” and “BCC” fields.
You can manually enter the content in the subject or the body field, or click the “Select Event Property” icon to select event properties. For example, if you select the [Job Name] event property, when the alert is triggered, the event property is replaced with “Job 1,” which is your real job name.
Click Test Mail to test the e-mail preferences.
The content of the subject and body in the test mail
is generated automatically by the system.
Filter:
Click the “Select Project or Job” icon and choose the project or job that should invoke the alert. Click OK.
The filter condition is generated automatically. However, if required, you can manually edit the filter condition.
If you are entering the filter condition manually, click the “Select Event Properties” icon to choose the event properties.
Select Include to be notified when the events for the project or job match the filter condition. Select Exclude to be notified when the filter conditions are not met.
Select “Enable alert during simulation” to be notified of an event during simulation. This option is available only for project events.
Click Save.
In the Alerts pane, click the alert.
Modify the alert preferences and click Save.
Select the alert to remove and click the Delete icon.
Select the alert you want to copy.
Click the Save As icon.
Enter a name for the new alert.
Modify the e-mail preferences and filter conditions for the alert, if required. Click Save.
Sybase recommends that you set up e-mail alert notifications
on one machine. You can then manually copy the alert configuration
file across different grid engines running on the network. Use a
text editor to define the alerting configuration in the “SMTP” section
of the default.ini file in the etc directory.
