...
Code Block | ||||
---|---|---|---|---|
| ||||
<?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>
|
- Order : get_order_date
Code Block | ||||
---|---|---|---|---|
| ||||
<?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> |
- Order : get_last_booking_date
Code Block | ||||
---|---|---|---|---|
| ||||
<?xml version="1.0" encoding="ISO-8859-1"?> <job_chain orders_recoverable="yes" visible="yes"> <order title="Calculate Order Date"> <params > <param name="command" value="C:/app/executables/plsql/get_last_booking_date.sql"/> <job_chain_node state="execute_plsql" job="JITL-PLSQL" next_state="sucess" error_state="error"/</params> <run_time let_run="no"> <job_chain_node <period statesingle_start="sucess08:00"/> <job_chain_node state="error"/></run_time> </job_chain>order> |
...
How can results be used in subsequent jobs?
...