...
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> |
...