Page History

<?xml version="1.0" encoding="ISO-8859-1"?>

<job_chain  orders_recoverabletitle="yesExecute PL/SQL procedure" visibleorder="yes">
    <settings >
    <job_chain_node  state="execute_plsql" job="JITL-PLSQL" next_state="sucess" error_state="error"/>
    <job_chain_node  state="sucess <log_level ><![CDATA[debug9]]></log_level>
    </settings>
    <description >
        <include  file="jobs/JobSchedulerPLSQLJob.xml"/>
    </description>
    <params >       
         <!-- Parameter can be passed by task or as order param -->
        <param  name="date_mask" value="YYYYMMDD_HH24MI"/>       
 
        <!-- Database connection parameters i.e. db_url, db_user, db_password -->
        <include  live_file="../common_settings/database/database_connection.params.xml" node=""/>
    </params>
    <script  language="java" java_class="sos.scheduler.db.JobSchedulerPLSQLJobJSAdapterClass"/>
    <job_chain_node  state="error"<run_time />
</job_chain>

job>

<?xml version="1.0" encoding="ISO-8859-1"?>
<job_chain<order  orders_recoverabletitle="yes" visible="yes"Calculate last booking date">
    <params >
    <job_chain_node    <param  statename="execute_plsqlcommand" job="JITL-PLSQL" next_state="sucess" error_state="error"/>value="C:/app/executables/plsql/get_last_booking_date.sql"/>
    </params>
    <job<run_chain_nodetime  statelet_run="sucessno"/>
    <job_chain_node    <period  statesingle_start="error11:00"/>
    </job_chain>run_time>
</order>