Page History

 <[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/order.xml order] title="update MY_TABLE">
     <params>
         <param name="statement_newline" value="__xA0x0A__"/>
         <param name="statements"        value="update MY_TABLE set a='foo' where b='bar';__xA0x0A__commit;"/>
     </params>
     <run_time/>
 </order>

 <[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/job.xml job] title="Launch Database Statement">
     <params>
         <param name="statement_newline"       value="__xA0x0A__"/>
         <param name="statements"              value="update MY_TABLE set a='foo' where b='bar';__xA0x0A__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
  mysqlErr=$?
  rm myupdate.sql
  exit $mysqlErr
         ]]>
     </script>
     <run_time/>
 </job>