Table of Contents | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
We recommend using our SQL*Plus job for working with SQL*Plus and the Oracle relational databaseDBMS.
This is one of our JITL jobs that are delivered provided with JobScheduler.
Use JOE to create a an SQL*Plus job .like this:
- open Open the wizard
- select Select SOSSQLPlusJob in the list of available jobs and enter a job name
- goto Goto "next" to set some parameters for the database connection etc.
- follow
Follow the above link to get more information about the parameter etc.
*after you have finished the wizard then you can insert theNo Format After you finished the wizard you can insert the SQL*Plus
script
in
the
script
tab
of
the
job.
*alternatively you can put theAlternatively you can put the SQL*Plus
script
in
an
external
file
and
enteradd this
filename
into the
parameter
_sql_script_file
_.
ExampleYou get a job like the following:
Code Block | ||
---|---|---|
| ||
<?xml version="1.0" encoding="ISO-8859-1"?> <job title="Start SQL*Plus client and execute aan sqlSQL*plusPlus script" order="no"> <description > <include file="jobs/SOSSQLPlusJob.xml"/> </description> <params > <param name="db_url" value="test"/> <param name="db_user" value="test"/> <param name="db_password" value="test"/> </params> <script language="java" java_class="sos.scheduler.db.SOSSQLPlusJobJSAdapterClass"> <![CDATA[ WHENEVER SQLERROR EXIT SQL.SQLCODE WHENEVER OSERROR EXIT FAILURE prompt Hello World; / exit; ]]> </script> <run_time /> </job> |