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