...
The job launchDB.job.xml (i.e. with a MySQL database connection, examples for other DBMS see below): It executes the statements where the statement in the order command parameter overwrites the statement in the job command parameter.
...
MySQL (MariaDB)
Code Block |
---|
<job title="Launch Database Statement" order="yes" stop_on_error="no"> <description> <include file="jobs/JobSchedulerManagedDatabaseJob.xml"/> </description> <params> <param name="db_class" value="SOSMySQLConnection"/> <param name="db_driver" value="com.mysql.jdbc.Driver"/> <param name"db_url" value="jdbc:mysql://localhost:3306/scheduler"/> <param name="db_user" value="scheduler"/> <param name="db_password" value="scheduler"/> <param name="command" value=""/> </params> <script language="java" java_class="sos.scheduler.managed.JobSchedulerManagedDatabaseJob"/> <run_time/> </job> |
For other database management systems you have to modify the connection parameter like in the following examples:
MS
...
SQL
...
Server
Code Block |
---|
<job title="Launch Database Statement" order="yes" stop_on_error="no"> <description> <include file="jobs/JobSchedulerManagedDatabaseJob.xml"/> </description> <params> <param name="db_class" value="SOSMSSQLConnection"/> <param name="db_driver" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/> <param name="db_url" value="jdbc:sqlserver://localhost:1433;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=scheduler"/> <param name="db_user" value="scheduler"/> <param name="db_password" value="scheduler"/> <param name="command" value=""/> </params> <script language="java" java_class="sos.scheduler.managed.JobSchedulerManagedDatabaseJob"/> <run_time/> </job> |
...