Before and after tasks

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Before and After tasks</name>
     <description>This scenario demonstates before and after tasks.</description>
     <script>before_after_task</script>
     <driver>auto</driver>
     <variables>
          <GLOBAL_VAR label="Global" value="global"/>
     </variables>

<beforetasks>
          
          <task>
               <name>drop_staging_table_before</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <driver>auto</driver>
               <sql>drop table staging_employee</sql>
               <onexception action="ignore"/>
          </task>
          
          <task>
               <name>create_staging_table</name>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <connection>dest</connection>
               <driver>auto</driver>
               <sql>
                  create table staging_employee (
                    EMPNO	     varchar(6),
                    FIRSTNME	varchar(12),
                    LASTNAME	varchar(15),
                    JOB	     varchar(8),
                    GLOBAL_VAR  varchar(100),
                    LOCAL_VAR   varchar(100)
                  );
               </sql>
          </task>
     </beforetasks>
     <sources>
          <source>
               <name>staging_employee</name>
               
               <extract>
                    <sql>select * from employee</sql>
               </extract>
               <tasks>
                    
                    <task scope="inline">
                         <name>copy</name>
                         <connection>dest</connection>
                         <class>com.toolsverse.etl.core.task.common.SqlTask</class>
                         <driver>auto</driver>
                         <variables>
                              <TASK_VAR value="task"/>
                         </variables>
                         <sql>
                             insert into staging_employee
                             values ({EMPNO}, {FIRSTNME}, {LASTNAME}, {JOB}, {GLOBAL_VAR}, {TASK_VAR});
                         </sql>
                         <using>GLOBAL_VAR,TASK_VAR</using>
                    </task>
               </tasks>
          </source>
     </sources>

<destinations>
          <destination>
               <name>employee_cursor</name>
               <tablename>employee_before_after</tablename>
               <metadata>true</metadata>
               <cursor sql="select * from staging_employee"/>
          </destination>
     </destinations>

<aftertasks>
          
          <task>
               <name>drop_staging_table_after</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>drop table staging_employee</sql>
          </task>
     </aftertasks>
     
</scenario>