Enable e-mail alerts for processing job failures
Article ID: 173566
Updated On:
Products
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:
- Open SQL Server Management Studio (SSMS)
- Connect to the Database Engine that hosts the RiskFabric database
- In Object Explorer, navigate to SQL Server Agent > Operators
- Right-click the Operators folder and select New Operator
The New Operator window will open - Enter an operator Name and E-mail name and ensure the Enabled box is checked
- Click the OK button to close the New Operator window
- In Object Explorer, navigate to SQL Server Agent > Jobs
- 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 - Select the Notifications page
- 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
- 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.
Feedback
