Enable e-mail alerts for processing job failures

Products

• Information Centric Analytics
• Data Loss Prevention Core Package

Issue/Introduction

Can Information Centric Analytics (ICA) notify administrators by e-mail when either the RiskFabric Processing or RiskFabric Intraday Processing jobs fail?

Environment

Version : 6.x

Component : Microsoft SQL Server

Resolution

ICA does not provide e-mail notifications for job failures; however, Microsoft SQL Server can be configured to provide e-mail alerts.

NOTE: SQL Server's Database Mail feature must first be enabled and configured. Refer to the following Microsoft document for more information:
https://learn.microsoft.com/en-us/sql/relational-databases/database-mail/configure-database-mail?view=sql-server-ver16

Once Database Mail is enabled and configured, the following procedure will configure SQL Server to notify administrators by e-mail when either of the RiskFabric processing jobs fail:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Database Engine that hosts the RiskFabric database
3. In Object Explorer, navigate to SQL Server Agent > Operators
4. Right-click the Operators folder and select New Operator
   The New Operator window will open
5. Enter an operator Name and E-mail name and ensure the Enabled box is checked
6. Click the OK button to close the New Operator window
7. In Object Explorer, navigate to SQL Server Agent > Jobs
8. Right-click the RiskFabric Processing or RiskFabric Intraday Processing job and select Properties
   The Job Properties - RiskFabric Processing or Job Properties - RiskFabric Intraday Processing window will open
9. Select the Notifications page
10. Check the box labelled E-mail, select the new operator from the first drop-down list, and select When the job fails from the second drop-down list
11. Click the OK button to close the Job Properties window

NOTE: Broadcom does not provide support for Microsoft's SQL Server Database Mail feature. For support or assistance with any of the steps above, contact Microsoft for assistance.