...
The documentatin of the job JobSchedulerPLSQLJob.xml JobSchedulerPLSQLJob can be found in the ./jobs directory of the JobScheduler installation.
...
| Code Block | ||
|---|---|---|
| ||
<job title="Execute PL/SQL procedure" order="yes" name="TestSQL">
<params >
<param name="command" value="begin myTestProc; end;"/>
<param name="db_url" value="jdbc:oracle:thin:@ur-lAsss:1521:XE"/>
<param name="db_user" value="scheduler"/>
<param name="db_password" value="scheduler`getDBPassword`"/>
</params>
<script language="java" java_class="sos.scheduler.db.JobSchedulerPLSQLJobJSAdapterClass"/>
</job>
|
...
The SendEmail job comes from the JITL library.
| Code Block | ||
|---|---|---|
| ||
<job title="Send Mails" order="yes" stop_on_error="no" name="SendMail">
<description >
<include file="jobs/JobSchedulerManagedMailJob.xml"/>
</description>
<params >
<param name="to" value="info@sos-berlin.com"/>
<param name="subject" value="Result from oracle"/>
<param name="host" value="smtp_host"/>
</params>
<script language="java" java_class="sos.scheduler.managed.JobSchedulerManagedMailJob"/>
<monitor name="configuration_monitor" ordering="0">
<script java_class="sos.scheduler.managed.configuration.ConfigurationOrderMonitor" language="java"/>
</monitor>
<run_time />
</job>
|
...