Skip to Content
0

Unable to schedule procedure through xsjob without parameters

Nov 24, 2017 at 09:39 AM

76

avatar image
Former Member

Hi All,

We are trying to schedule a procedure through xsjob below is the code--

xsjob---

{ "description" : "Run the procedure",

"action": "package::PROCEDURE",

"schedules": [ { "description" : "Schedule Procedure",

"xscron" : "2016 * * * * * *"

} ] }

PROCEDURE----

PROCEDURE "_SYS_BIC"."package::PROCEDURE" ()

LANGUAGE SQLSCRIPT

SQL SECURITY INVOKER

--DEFAULT SCHEMA <default_schema_name>

--READS SQL DATA

AS

BEGIN

UPDATE "CUSTOM"."Table" SET "column" ='11';

END;

while trying to scheduled this procedure through design_time job its executed but while trying to run through run_time job its throwing the following error-----

Schedules.add: wrapping parameter object for sql script failed

But surprisingly while trying to schedule the procedure with parameters its working perfectly.

10 |10000 characters needed characters left characters exceeded

Please can you add more details to your question. E.g. what do you mean with "... through run_time job ..." (creating it via the XS Job Admin UI?). What settings you are using for the second attempt?

Regards,
Florian

0
Former Member
Florian Pfeffer

Hi Florian,

In .xsjob file while i am setting xscron as 2017 * * * 12 15 0 and checking the log in XS Job Admin UI its executed successfully but when I am adding a new Schedule through XS Job Admin UI that time the job not saved ending with error--

Schedules.add: wrapping parameter object for sql script failed

For the second attempt also using XS Job Admin UI only.The difference is for 2nd case we are using parameters to the procedure.

Regards,

Mousumi

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers