...
The Managed Jobs PHP web interface provides a text textarea for this area, while in the Job Scheduler Object Editor (JOE), only one an input field is available.
PHP converts the textarea hexadecimal because a newline can not be written in an XML attribute.
If you want to use the job with multiple statements without the MANAGED JOBS, then the statements must be changed hexadecimal.
The following is an example of a job chain in which the statements are converted before launching.
...
| Code Block |
|---|
<[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/job.xml job] title="Launch Database Statement" order="no" stop_on_error="yes">
<params>
<param name="statement_newline" value="__xA0__"/>
<param name="statements" value="update MY_TABLE set a='foo' where b='bar';__xA0__commit;"/>
<param name="db" value="scheduler"/>
<param name="db_user" value="scheduler"/>
<param name="db_password" value="scheduler"/>
</params>
<script language="shell">
<![CDATA[
echo $SCHEDULER_PARAM_STATEMENTS | sed -e 's/'$SCHEDULER_PARAM_STATEMENT_NEWLINE'/\n/g' > myupdate.sql
mysql -u$SCHEDULER_PARAM_DB_USER -p$SCHEDULER_PARAM_DB_PASSWORD $SCHEDULER_PARAM_DB < myupdate.sql
rm myupdate.sql
]]>
</script>
<run_time/>
</job>
|