Activity for Rico Rauch
-
Rico Rauch posted a comment on discussion Help
Any idea on my question?
-
any help? does anybody use PLSQL-Jobs with Params?
-
Hi How can I read Params in a PLSQL-command? I tried it as described in https://kb.sos-berlin.com/display/PKB/Job+JobSchedulerPLSQLJob My Job: <?xml version="1.0" encoding="ISO-8859-1"?> <job order="no" title="test"> <params > <param name="testparam" value="test"/> <param name="db_url" value="jdbc:oracle:thin:@//xx.xx.x.x:xxxx/xxx.xxxxxx.xx"/> <param name="db_user" value="xxxxx"/> <param name="db_password" value="xxxxx"/> <param name="command" value=" BEGIN INSERT INTO T_SOS_TEST VALUES ('\${SCHEDULER_PARAM_testparam}');...
-
Hi Andreas Thank you for your reply. I didn't realized that SCHEDULER_PARAM_XXX are System-Environment-Variables. I thought they are only valid in the JobScheduler Application (and API). With your example I can read the Params. About one point I am still not shure about: To run Python-Scripts I need to create a Job in one of the supported langauges? e.g Shell,Powershell... and from there I call the Script? For example: <?xml version="1.0" encoding="ISO-8859-1"?> <job > <script language="shell"> <![CDATA[...
-
Hi Andreas Thank you for your answer. Sorry for missunderstanding. I was talking about Jython. The dead link in the documentation is in chapter 6 -> https://scripting.dev.java.net/servlets/ProjectDocumentList (JS223-engines) You write that I can run Python scripts out-of-the-box. I allready have (windows-)shell-Jobs in which i call Python-Scripts. Do you mean jobs like this? The problem here is that I dont have access to JobScheduler-Params and Environment-Variables. As a workarround I send all params...
-
Hi I would like to create a job runing python-code I followed the docu on http://www.sos-berlin.com/doc/en/scheduler-javax-scripting.pdf There is a link in to docu where the engines could be downloaded. The link is dead. Does anybody have a source where I can get this jar-file? I found a jar file on http://www.java2s.com/Code/Jar/j/Downloadjythonenginejar.htm It seams that the python engine starts but ist returns an error: 2017-11-15 14:21:34.182+0100 [ERROR] COM-80020009 Exception occurred. [begin]...
-
Hi I changed the value for configuration_directory in scheduler.xml and moved all folders from the default live-folder to the new folder. All Jobs work as they should. Only the SOS-Job createDailyPlan ends with node "error", but Status successful. log-entry: hibernate config file not found: D:\hibernate.cfg.xml Part in log-file: JobSchedulerLog4JAppender (system.out): ERROR [main] (CreateDailyPlanJSAdapterClass.java:33) - hibernate config file not found: D:\hibernate.cfg.xml Do I need to change some...
-
Good morning Andreas Thank you for your help and the link. That's what I was looking for. Regards Rico
-
Hi In a XML-File I have defined all my params One of these params has the $-sign in the value. I am not able to read and output the full value of the param. I get only the part before the $-sign. How can I get the correct value? Thanks for any help Rico param.xml <?xml version="1.0" encoding="UTF-8"?> <params> <param name="myparam" value="blabla$blabla" /> </params> Powershell-Code in the job $params = $spooler_task.params() $myparam = $params.value( "myparam" ) echo "myparam: $myparam" --> Output:...
1
