on 10-25-2015 10:21 AM
Sumeet,
make sure the job scheduler is enabled in the xs dashboard screen.
URL/sap/hana/xs/admin/jobs/
and in your specific job settings, make sure it is active..
it seems like you created the job but it is not currently active.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Sumeet,
can you share your xsjob file content. On which HANA revision you are? What is displayed in the XS Job Dashboard?
Best Regards,
Florian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi florian,
Here you go. I am on revision 9. In search tab, its showing my job but when i click on the same, it doesn't open up.
{
"description": "Job to Update INSERT values",
"action": "exercises_UI::insert_values",
"schedules":
[
{
"description": "Table will be INSERTED after every 60 sec",
"xscron": "* * * * * * 60"
}
]
}
PROCEDURE "BEST"."exercises_UI::insert_values" ( )
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER
DEFAULT SCHEMA "BEST"
--READS SQL DATA
AS
BEGIN
/*****************************
Write your procedure logic
*****************************/
insert INTO "BEST"."ZKNA1" values ('13200','AKSHIT','55','NL04');
insert INTO "BEST"."ZKNA1" values ('13201','SOPHIE','33','NL04');
END;
Br
Sumeet
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.