Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Execute simultaneouslyl stored procedures on different hosts

  1. #1

    Question Execute simultaneouslyl stored procedures on different hosts

    Hi everyone,

    i have the same stored procedure on differet hosts like this:

    Host1 -> sqlserveristance--> master(db) ---> sp_name
    Host2 -> sqlserveristance--> master(db) ---> sp_name
    ....
    For each sp the execution time is long, that's why I would like to execute at the same time and not sequentially.
    Hosts name is stored insidea file, for every one I set envirorment variables to use in database connection parameter.
    That is exactly what looks like my job:

    Job1
    Trasformation1.1 --read file and copy rows to result
    Job2 ( checked "execute for every input row")
    Trasformation2.1 --get rows from result and set variables Hostname
    Trasformation2.2 -- use ${HostName} to execute sql script

    ..but it seems that each SQL script is being run sequentially.

    Appreciate all your time and inputs!

    Thanks
    Last edited by dataexplorer; 03-08-2017 at 09:04 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.