...
(A general overview of all JITL jobs can be found here___found Features - JITL).
The description JobSchedulerManagedDatabaseJob.xml is stored in the ./jobs directory of the JobScheduler installation.
...
| 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 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]
...