...
| Code Block |
|---|
<[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/order.xml order] title="update MY_TABLE">
<params><[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/params.xml params]>
<param <[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/param.xml param ]name="command" value="update MY_TABLE set a='foo' where b='bar';&#10;commit;"/>
</params>
<run_time<[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/run_time.xml run_time]/>
</order>
|
The job launchDB.job.xml: It executes the statements.
...
| Code Block |
|---|
<[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/job.xml job] title="Launch Database Statement" order="yes" stop_on_error="no">
<description>
<include file="jobs/JobSchedulerManagedDatabaseJob.xml"/>
</description>
<params><[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/params.xml params]>
<param <[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/param.xml param ]name="db_class" value="SOSMySQLConnection"/>
<param <[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/param.xml param ]name="db_driver" value="com.mysql.jdbc.Driver"/>
<param <[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/param.xml param ]name="db_url" value="jdbc:mysql://localhost:3306/scheduler"/>
<param <[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/param.xml param ]name="db_user" value="scheduler"/>
<param <[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/param.xml param ]name="db_password" value="scheduler"/>
<param <[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/param.xml param ]name="command" value=""/>
</params>
<script <[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/script.xml script ]language="java" java_class="sos.scheduler.managed.JobSchedulerManagedDatabaseJob"/>
<run_time<[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/run_time.xml run_time]/>
</job>
|