Skip to Content
0
May 21, 2018 at 11:16 PM

Scheduling Stored Procedure via XS Job Issue

1147 Views

Hello,

I've created the stored procedure below in HANA which I'd like to schedule via an XS Job.

It can also be seen here in the catalog:

And this is the name that I see it in the SQL prompt when creating it:

PROCEDURE "49_LOCALYTICS"."StoredProcedures::LOC_NEW_DEVICE_MOVE" ( ) LANGUAGE SQLSCRIPT SQL SECURITY INVOKER AS etc. etc.

I can manually call the procedure via the SQL prompt and I know it is working.

I have created the xsjob and the xsjs files as shown below:

xsjob:

xsjs:

I've scheduled the job through the XS page but the error I'm getting seems to indicated that I'm not passing the correct path for my stored procedure in the XSJS file:

I've tried several different combinations of what I think should be the correct path, but I keep facing this error.

Am I missing something blatantly obvious, or can someone shed some light on the correct syntax?

Thank you,

Marcelo

Attachments

1.png (15.1 kB)
1.png (10.2 kB)
1.png (15.0 kB)
1.png (15.4 kB)
1.png (23.4 kB)