...
JITL: The Managed Database Job
| Info | ||
|---|---|---|
| ||
This job uses the deprecated sos.scheduler.managed.JobSchedulerManagedDatabaseJob that has been deprecated with Release 1.12. The JobSchedulerManagedDatabaseJobSOSHibernate job is provided as an alternative. |
This job is used is used standalone or triggered by orders to execute (SQL-)statements in a database and can be used standalone or triggered by orders - i.e. as an order job.
These It can be execute database procedures or SQL statements.
(A general overview of all JITL jobs can be found here___found Library of Standard Jobs - JITL).
The description JobSchedulerManagedDatabaseJob.xml is stored in the ./jobs directory of the JobScheduler installation.
...
| Code Block |
|---|
<order title="update MY_TABLE">
<params>
<param name="command" value="update MY_TABLE set a='foo' where b='bar';&#10;commit;"/>
</params>
<run_time/>
</order>
|
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>
|
...
| 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="SOSOracleConnection"/>
<param name="db_driver" value="oracle.jdbc.driver.OracleDriver"/>
<param name="db_url" value="jdbc:oracle:thin:@localhost:1521: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>
|
see See also:
- ORACLE___How to run an Oracle Stored Procedure Procedures using PL/SQL
How to work with PL/SQL and the Oracle DBMS
No Format *[Working with SQL*Plus|Working with SQL*Plus]
...
PostgreSQL
| Code Block |
|---|
<job title="Launch Database Statement" order="yes" stop_on_error="no"> <description> <description> <include file="jobs/JobSchedulerManagedDatabaseJob.xml"/> </description> <params> <param name="db_class" value="SOSPgSQLConnection"/> <param name="db_driver" value="org.postgresql.Driver"/> <param name="db_url" value="jdbc:postgresql://localhost:5432/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> |
IBM/DB2
| Code Block |
|---|
<job title="Launch Database Statement" order="yes" stop_on_error="no"> <description> <description> <include file="jobs/JobSchedulerManagedDatabaseJob.xml"/> </description> <params> <param name="db_class" value="SOSDB2Connection"/> <param name="db_driver" value="com.ibm.db2.jcc.DB2Driver"/> <param name="db_url" value="jdbc:db2://localhost:50000/scheduler:driverType=2;retrieveMessagesFromServerOnGetMessage=true;"/> <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> |