Scheduling Options to control multiple .xsjobs

[Former Member]

Dear Experts,

I would like to know available options in SAP HANA to control the multiple .xsjobs at a time using either or a tool or script.

After watching below video from Mr. i created few xsjobs to trigger sql procedures successfully but now i want to control them at a time.

SAP HANA SPS 07 Job Scheduling - YouTube

My questions are:

1) I saw in the end of the video Thomas mentioned something about api and a xsjs script to start and stop the same two jobs by commands but not clear for me if we can just directly execute them.

2) I tried to write an update script to set the status of the jobs to 'Active' so that it should start the jobs but realized it won't work as the password entrance is not possible due to security reasons. So any other system log view tables can do the work to start or stop list of jobs ?

3) Is there any GUI in XS admin tool to control multiple jobs at a time instead of java scripts?

Thanks

Ranjith

rnandiraju@munichre.com

[pfefferf · Accepted solution]

Hello Ranjith,

regarding point 1 and 2) There exists a Job scheduling API (JSDoc: Namespace: jobs) for XSJS which you can use to schedule your jobs. You should NEVER update directly any system tables to activate a job.

Regarding point 3) There is the XS Job Dashboard were you can control the jobs on a single level, but not on a multiple level (e.g. marking several entries and unschedule them).

Best Regards,

Florian

[Former Member · Accepted solution]

Hi Florian,

Thanks for the response! I will try it and post how it works. Yes I don't want to change any system tables as a solution but gave it a try to see if it works ..

If the dashboard has a GUI functionality for controlling multiple jobs might have been better.

Thanks

Ranjith

[Former Member]

Hi Florian Pfeffer

With couple of examples in SAP HANA demo i could create complete solution of scheduling as required even using the secure store for password handling. Thanks for the initial pointers to the documentation.

I also saw one of your answer for clearing the job log entries, that you suggested to write a deletion job to delete entries lees than so&so time period from system table.

Any news for controlling job entries in future SPS11? we are triggering some jobs for every 3 minutes which means we end up with lot of log entries and we don't want so much of the log data.

Thanks

Ranjith

[Former Member]

Hi Florian,

using the documentation from xs dashboard from xs admin i was able to write a xsjs script which controls my list of xsjobs dynamically. My requirement is to start the real time replication flow graphs only once so i used some sql statement to get the date and time in UTC format and gave start and end date time as same. By doing so the xsjob with xscron * * * * * * * i achieved to schedule the jobs only once when ever triggered using the system UTC time.

select TO_VARCHAR(CURRENT_UTCDATE, 'YYYY MM DD') || ' '|| TO_VARCHAR(ADD_SECONDS (CURRENT_UTCTIME, 60*3)) from dummy

Thanks

Ranjith