2 Replies Latest reply on Dec 19, 2017 4:48 AM by philippe lambrecht

    ETL tasks with gateways ?

    philippe lambrecht

      Hello,

       

      How to have the list og ETL tasks with Gateway associated, exemple :

       

      ETL_Number1  ShedulerName1 Gateway1

       

      Thanks.

        • 1. Re: ETL tasks with gateways ?
          Marco Colombo

          Here is

           

          select
          p.taskpsetid,
          pt.taskid as etl_id,
          t.name as etl_name,
          p.value as gm,
          s.schedulerid,
          c.name as scheduler,
          h.hostname as scheduler_host
          from
          task_pset_props p 
          join task_pset pt on p.taskpsetid=pt.taskpsetid
          join task t on pt.taskid = t.taskid
          join scheduler_def s on t.schedulerid=s.schedulerid
          join component_def c on s.componentid=c.componentid
          join host_def h on c.hostid=h.hostid
          where
          p.taskpsetid in(
          select
          taskpsetid
          from
          task_pset
          where
          taskid in(
          select taskid from task where etlmodid = 120
          )
          )
          and p.name = 'extract.bpa.gm.url'
          

           

          This query get all VIS file parser connected to a gateway server as list associated host/scheduler.

           

          Regards

          2 of 2 people found this helpful
          • 2. Re: ETL tasks with gateways ?
            philippe lambrecht

            Great ! Thank you.