Hello All,

We have got a very different requirement, which is really new to us. We need to trigger an email from a daily scheduled report, whenever there is a count mismatch or a condition failure. Is that possible in WebFOCUS?

Let me try to explain a bit in detail, say we have scheduled a car report in Excel format to be delivered in Report Library eveyday. While the report is delivered and whenever the sales is less than 1000$ then a email needs to be sent for a particular user saying that your sales is low today. Hope, I made this clear.

Any insights would be be much helpful. If there are no direct options please suggest round about options as well.

Thanks in advance.

This message has been edited. Last edited by: Ramkumar - Webfous,

Hi Ramkumar

If all else fails.

What we have been doing is to call a perl script to send emailes in these situations.

The perl scriot we use is called sendemail.pl. You will need to install perl on the server with WebFOCUS.

This message has been edited. Last edited by: Waz,

Thank you Waz for the reply. Let me check the possibility of installing perl with our Admins. Mean while, I am seeing something called Alert Assist in 8.. Not sure, if this will satisfy me needs.

https://mymerchinfo.com/ibi_he...source%2Ftopic84.htm

Hi Ramkumar,
Try exploring around DSTRUN function. This is used to trigger the reportcaster job from fex file.

Ramkumar,

I am using scheduled Alerts in WebFOCUS 8. It is a great way to schedule an email alert when a report is actually generated, in your case, when sales are below $1000. I have 4 reports that run every day to check for missing dimensions in data entered by users, if a report is generated the scheduled alert sends an email message to the users to let them know they have an issue to address.

Teri

Hi,

We use and alert schedule that sends our reports when conditions are met and then as a post process calls a fex that uses REST to kick off other schedules. As part of that we also use EDAMAIL to send emails when parts of the flow have errors. I would think you could use something similar. Use the alert schedule to send the main report to the library and then a post process to kick off a fex that checks for low sales and sends the email or even kick off a fex that runs a scedule that creates a burst report with condition of sales < 1000

Just a few ideas.

Crystal

Hi Ram,

You can use Alert feature for the functionality. Also, can use combination of Alert and EDAMAIL. Sample code for your reference.

-DEFAULT &UID = 'userid' ;

-SET &&TMPPATHDEF=TEMPPATH (60,'A60');
-SET &MAIL_FILE=&&TMPPATHDEF || 'maildef.txt';
FILEDEF MAILDEF DISK &MAIL_FILE
-RUN

-SET &TIMEIS = HHMMSS('A8');
-SET &HH = EDIT(&TIMEIS,'99$$$$$$');
-SET &MM = EDIT(&TIMEIS,'$$$99$$$');
-SET &SS = EDIT(&TIMEIS,'$$$$$$99');
-SET &NOWDATE=&YYMD;
-SET &THEYY=EDIT(&NOWDATE, '9999$$$$');
-SET &THEMMO=EDIT(&NOWDATE, '$$$$99$$');
-SET &THEDD=EDIT(&NOWDATE, '$$$$$$99');
-SET &CURDATE='Current Date = ' | &THEMMO | '/' | &THEDD | '/' | &THEYY;
-SET &CURTIME='Current Time = ' | &HH | ':' | &MM | ':' | &SS;

-WRITE MAILDEF Your file has been created.. Please login to see the output in BI Dashboard..
-WRITE MAILDEF
-WRITE MAILDEF "http://server.com/ibi_apps/WFServlet?IBIMR_action=MR_DEFER&|IBIMR_return=html&|IBIMR_sub_action=MR_DEFER_CONTROL&|IBIMR_random=0.07530228932039157"
-WRITE MAILDEF
-WRITE MAILDEF &CURDATE
-WRITE MAILDEF &CURTIME

-RUN

-MRNOEDIT EX EDAMAIL userid@email.com,,Email Test in Report,,TXT,MAILDEF

EDAMAIL works well, and is probably appropriate for an alert.

we had to find a different method because of the requirement to email zipped reports.

Thanks for all your replies... Will check all these options for a sure, and scheduled alerts looks promising for our requirement. Will Explore on that front as well..

Once again Thanks for the overwhelmed response.