...
| 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:
- How to run Oracle Stored 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
...
PostgreSQL
<job title="Launch
...
Database
...
Statement"
...
order="yes"
...
stop_on_error="no">
...
<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
...
...
<job
...
title="Launch
...
Database
...
Statement"
...
order="yes"
...
stop_on_error="no">
...
<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>
...