XSJS - Asynchronous call procedure

[Former Member]

Hi,

I have a procedure that takes a long time to run. My goal it's to execute the call procedure from the XSJS, but don't wait for the execution. I couldn't do this using $.hdb interface (SPS 10), it seems that it will always wait for the procure execution to complete. As it takes to long to run, I get:

The execution of the script has exceeded the maximum request runtime.

And everything is rolled back...

Any ideas ?

[former_member182500 · Accepted solution]

Get anywhere with this Lucas, I have a similar requirement to execute a procedure from within an xsjs asynchronously.

[thomas_jung · Accepted solution]

I would suggest scheduling this as an XSJOB dynamically.

JSDoc: Namespace: jobs

Add or Delete a Job Schedule during Runtime - SAP HANA Developer Guide for SAP HANA Studio - SAP Lib...

[Former Member · Accepted solution]

Hi Thomas,

Is there anyway to execute the xsjob just one time ? Something like the "execute immediate" when scheduling a JOB in sap netweaver..

[thomas_jung · Accepted solution]

You can always add a schedule dynamically:

http://help.sap.com/saphelp_hanaplatform/helpdata/en/89/1d9e6dd5144bac8c071ad155ddee8e/content.htm?f...

Within the XSCRON for you dynamic schedule you could always specify single date/time and therefore no re-occurrence.