Skip to Content

Problem:

When there is Data Load happens to the Data Target, there are situations where the Process got successfully completed but there are zero records fetched.

Before client escalates about the zero records being fetched to the data target we have to get this alert so that we can fix this issue.

In such scenarios, please follow the below steps to get an email alert once there are zero records fetched though the process got successfully completed.

Solution: Broadcast email Alert to your mailbox to work on the issue. Please follow below steps to configure Broadcasting of emails.

Goto:

Query in Designer.

/wp-content/uploads/2013/07/1_251723.jpg

Maintain an exception as required for the scenario.

/wp-content/uploads/2013/07/2_251724.jpg

Go with broadcasting settings

/wp-content/uploads/2013/07/3_251725.jpg

Go with create new settings

/wp-content/uploads/2013/07/4_251726.jpg

Maintain the settings for Exception Distribution tab as mentioned in below screen shot

/wp-content/uploads/2013/07/5_251727.jpg

Maintain User language as English.

/wp-content/uploads/2013/07/6_251728.jpg

Maintain the Exception Search on Cal Week as below.

/wp-content/uploads/2013/07/7_251729.jpg

Come back to Exception Distribution to maintain the parameter. Go with create parameter.

/wp-content/uploads/2013/07/8_251730.jpg

Maintain the Recipients list here. You can give more than one mail id separated by “ ; ”

/wp-content/uploads/2013/07/9_251731.jpg

Maintain the Subject and Body of the mail in TEST tab.

/wp-content/uploads/2013/07/10_251732.jpg

Transfer the values and save the settings by giving technical name.

/wp-content/uploads/2013/07/11_251733.jpg

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply