Description of JobSchedulerManagedDatabaseJob - Launch Database Statement
This job is used as a standalone solution or triggered by orders to execute statements in a database.
These can be database procedures or SQL statements.
The Managed Jobs PHP web interface provides a text for this area, while in the Job Scheduler Object Editor (JOE), only one 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.
<[http://www.sos-berlin.com/doc/en/scheduler.doc/xml/job.xml job ] title="Launch Database Statement" order="yes">
<description>
<include file="jobs/JobSchedulerManagedManagedDatabaseJob.xml" />
</description>
<params>
<param name="command" value="" />
<param name="database_connection" value="" />
<param name="db_class" value="" />
<param name="db_driver" value="" />
<param name="db_url" value="" />
<param name="db_user" value="" />
<param name="db_password" value="" />
<param name="resultset_as_warning" value="false" />
<param name="exec_returns_resultset" value="false" />
<param name="resultset_as_parameters" value="false" />
</params>
<script language="java" java_class="sos.scheduler.managed.JobSchedulerManagedDatabaseJob"/>
</job>