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.
Use JOE to create a PL/SQL job.
- open the wizard
- select JobSchedulerPLSQLJob in the list of available jobs and enter a job name
- goto "next" to set some parameters for the database connection etc.
- follow above link to get more information about the parameter etc..
- after you have finished the wizard then you can insert the PL/SQL script in the script tab of the job.
- alternatively you can put the PL/SQL script in an external file and enter this filename in the parameter "command".
You get a job like the following:
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>
|