| Table of Contents |
|---|
| outlinh1. true |
|---|
| outlinh1. true |
|---|
| 1 | printablefalse |
|---|
| 2 | stylh1. none |
|---|
| 3 | indent20px |
|---|
|
We recommend using our PL/SQLJob job for working with SQL and Oracle™ RDBMS.
This is one of our JITL jobs that are delivered with JobScheduler.
...
| Code Block |
|---|
|
<?xml version="1.0" encoding="ISO-8859-1"?>
<job title="Execute PL/SQL procedure" order="no">
<description >
<include file="jobs/JobSchedulerPLSQLJob.xml"/>
</description>
<params >
<param name="db_url" value="jdbc:oracle:thin:@localhost:1521:test"/>
<param name="db_user" value="test"/>
<param name="db_password" value="test"/>
</params>
<script language="java" java_class_path="" java_class="sos.scheduler.db.JobSchedulerPLSQLJobJSAdapterClass">
<![CDATA[
begin
dbms_output.put_line('hello world');
end;
]]>
</script>
<run_time />
</job>
|