cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to schedule a procedure

patrickbachmann
Active Contributor
0 Kudos

Hi folks,

Is it possible to schedule a SQLscript procedure to run on a nightly basis?  ie: a procedure that massages data and inserts new data into a table each night.  I realize this is more of a BW data warehousing solution but I am being asked this question.  Is there some way to invoke the procedure automatically?

Thanks,

-Patrick

Accepted Solutions (1)

Accepted Solutions (1)

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

Yes this is a new feature in SP7. You no longer have to use an external scheduler.  We have a job scheduler built into the XS Engine.  You can create a job definition via the new artifact xsjob and schedule it via the XS Admin tool (/sap/hana/xs/admin/).  You can refer to the HANA Developers' Guide for more details.

patrickbachmann
Active Contributor
0 Kudos

Hey thanks guys!  Nice to know we can do this in our current 68 and that if we upgraded soon we can use this new feature.  Excellent!

-Patrick

Answers (1)

Answers (1)

former_member182302
Active Contributor
0 Kudos

Hi Patrick,

Yes we can do with the help of schedulers from windows like Task scheduler or from unix like CRON and even you can use BODS for scheduling.

Do have a glance on this blog:

Regards,

Krishna Tangudu