Skip to Content
0

xsjob not activating

Nov 07, 2016 at 04:31 PM

16

avatar image
Former Member

Hi all,

I am not familiar with xsjobs and have been trying to learn to implement a requirement.

To start I am certified Hana Modeler but not good with the Development Perspective.

We have a BODS job that is supposed to run daily, and do a select from a couple tables and reload this data back into a new table which gets used in the data foundation of an ANALYTIC VIEW.

Our BODS person is having troubles and I would like to do the same logic with the XS Engine and xsjobs files with a SQLScript Procedure to complete this task.

Can anyone walk me through where I am going wrong??

Where do I need I need to create the Procedure? In the Catalog, Package, Repository, or Project Explorer?

If I do a Truncate of the table prior to each new load, do I need to make it a Temp Table? If it's a Temp Table will that work as the data foundation? Or is it better to drop the table and recreate it daily?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers