We are triggering Board procedure as part of the nightly process that runs every day to update data. Is there any way we can trigger last step to send out email to recipients about completion of procedure with including log
@Minh Rieckermann Yes you can do it, However, you need to have Broadcasting License.
Hi @Pramodkumar_AR ,
I'm appreciate your message. The function Broadcast does not enable on our side. Might be it requires separately license to activate Thanks,
Regards
Hi Minh, if your procedure is being triggered as a Scheduled Task then I'm afraid that a Broadcasting step won't work, the procedure needs to be user triggered for Broadcasting to work due to the way in which the mailer functionality works.
The only way you can really send out the email you describe is by having a separate Broadcast job scheduled under the Broadcasting section that runs after the scheduled end time of the load and uses a layout to generate the email, in that way you can use a flag set in the load itself to determine whether the load succeeded or failed and set the email content accordingly. You can also use the presentation in the Broadcast to display the log data as you mentioned if needed.
The other option if you have a SQL Server is to push the results via a Board Procedure to a Log Table in SQL Server with a trigger that fires and sends a SQL Server email with the details.
Bart Scott CFO Solutions LLC
Yep good point, it's also possible to send alerts through MS Teams as well using API integration https://learn.microsoft.com/en-us/graph/api/chatmessage-post?view=graph-rest-1.0&tabs=http
Thanks @Bart Scott for your help. It is great idea to import log file into table in SQL Server afterward design Agent Job to send notification Best regards,
Thanks
As @Robert Barkaway said, you can also integrate MS Teams - @Minh Rieckermann
here is the step-by-step guide
How to send notifications: Integration with MS Teams - Board Community
