Configuring the ETL job notification

You can configure DWD to send an email notification to the SQL Agent operator. The email notification indicates the job status if it failed or succeeded.

For every ETL job created, a notification job will be added. This job will automatically start when the ETL job has finished.

  1. Open DWD Designer. Click the Execution menu.
  2. Select Job Notification. The Job Notification window will be shown.
    Note: If it is disabled, it means that the database mail and operator is not yet configured in SQL Server Management Studio.
  3. In the From Mail Profile drop-down menu, select a mail profile. These profiles are based on the SQL database mail list account. This will be the sender of the email notification.
  4. In the To E-mail Group drop-down menu, select an email group. These are based on the created operators on SQL Agent. This group will be the recipient of the email notification.
  5. In the Date Format drop-down menu, select a format.
  6. Select the check box to enable which job sends the email notification. These are the options:
    • E-mail when job succeeds
    • Email when job fails
    You can add a specific message depending on the status of the job execution.
  7. Click OK. A notification job will be added on every ETL job created.