Scheduling an XS job that calls SQLScript

[patrickbachmann]

Hi experts,

I recently upgraded to SPS07 and would like to use new XS job scheduling feature.  I'm looking at tutorial in latest HANA Developer Guide and it says I can call either Javascript file or SQLScript however the tutorial only shows the Javascript example.  For example I want to call a depricated SQLScript procedure so I'm not clear on the syntax after reading the tutorial.  The guide suggests the following for Javascript;

{

"description": "Read stock value",

"action": "yahoo:yahoo.xsjs::readStock",

"schedules": [

{

"description": "Read current stock value",

"xscron": "* * * * * * 59",

"parameter": {

"stock": "SAP.DE"

}

}

]

}

How would I change this to call my SQLScript procedure if, for example, my procedure was located in a package like this;

PROD/InitializeSalesLoad.procedure

Thanks,

-Patrick

[former_member182114 · Accepted solution]

Hi Patrick,

I found an example on video, Thomas shown both there.

About the name, it's a caracteristic of .procedure to create a synonym with this syntax package::procedurename. So it's probably PROD::InitializeSalesLoad

I don't have a system ready to test it, take a look if you find with

select * from synonyms where synonym_name like '%InitializeSalesLoad%'

Regards, Fernando Da Rós

[patrickbachmann · Accepted solution]

Fernando, many thanks!  The video clarified things.  I had a small hiccup where I had to add scheduler parameter to hana configuration before it would execute but now have it working. 

-Patrick