Skip to Content
avatar image
-2
Former Member

I have a data base created and I want to store the data that has crossed the threshold value.

I want trigger an email to the respective person mentioning that the value has crossed the threshold level.

Is it possible to do that using XSJS, if so can you please guide me to go on with the requirement?

Thanks & regards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 27, 2017 at 05:48 PM

    Hi Vanitha,

    It is certainly possible to to do it in xsjs.

    In the SAP HANA XS Classic development guide at:

    https://help.sap.com/doc/fbb802faa34440b39a5b6e3814c6d3b5/2.0.02/en-US/SAP_HANA_Developer_Guide_for_SAP_HANA_Studio_en.pdf

    Section 9.4 Using the Server-Side JavaScript APIs, and in it Outbound API section, shall help you writing the logic for sending the mail.

    While, to know if it has reached a threshold, you would need to schedule a job. The job shall run every regular intervals, which you could use to determine if the threshold is reached via a sql query.

    The information for the same is also maintained in the same guide in Section 9.7 Scheduling XS Jobs

    Thank you.

    Best Regards,

    Anjali.

    Add comment
    10|10000 characters needed characters exceeded