Unable to schedule procedure through xsjob without parameters

[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.

[pfefferf]

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

[Former Member]

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