...
| Code Block |
|---|
<job title="Execute PL/SQL procedure" order="no" 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"/>
</params>
<script language="java" java_class="sos.scheduler.db.JobSchedulerPLSQLJobJSAdapterClass"/>
</job>
|
Running this job will produce output in the log
| Code Block |
|---|
2013-04-03 10:29:21.477 [info] The value of variable "vCounter" is: [5495]
|