...
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"/>
<param name="command" value=""/>
</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>
|