Enable e-mail alerts for processing job failures
search cancel

Enable e-mail alerts for processing job failures

book

Article ID: 173566

calendar_today

Updated On:

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.