Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Executing xsjob in sap hana

Hello Experts,

I'm trying to execute a background job using SQL procedure in sap hana studio. I have written a xsjob and also a SQL procedure. I have also saved it and activated it using  XS admin tool. The problem is when I  try to run the script in SAP HANA studio, It gets scheduled but doesn't display the output. In XS admin tool I'm getting error message stating " SQL exception 258: insufficient privilege: Not authorized at ptime/query/checker/query_check.cc:2422". I have even written the scripts for .xsaccess,.xsprivileges and .xsapp(This is blank). Do I need to provide more permissions? Please help me to solve this issue. I'm herewith enclosing my SQL procedure and .XSJOB script.

demosql.xsjob

{ "description": "First SQL job",

"action": "Testdemo::jobsCreateEntry",

"schedules":

[ { "description": "This job will run every minute",

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

  }

   ]

}

jobsCreateEntry (SQL Procedure)

PROCEDURE "TEST1"."Testdemo::jobsCreateEntry" ()

LANGUAGE SQLSCRIPT

SQL SECURITY INVOKER

DEFAULT SCHEMA TEST1 AS

BEGIN

select * from TESTABLE;

END;

For your reference

The project name is : Testdemo

The schema used is : TEST1

The table in the schema is TESTABLE

Thanks

Madhav J

Tags:
Former Member
Former Member replied

Hi Thomas,

Initially I was using incorrect username and password. But now I tried with user as SYSTEM and the associated password. It displayed the message SUCCESS in XS Admin tool. But the I'm not getting the required output that is  I should get displayed with the contents of the table TESTABLE..

Thanks

Madhav J

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question