Automate

 View Only

  • 1.  How to send chained query scrips through email (or how to save in folder)?

    Posted 05-10-2022 11:15
    We have a number of chained query scripts our team uses, but we are having issues transferring the script from person to person. 
    If we email a chained script, it returns a "This chain is already part of a script error". If we save it in a shared folder, it never opens the file at all. 

    What we have had to do is open each chain and manually chain them on each of our computers, but this is a hassle (and is a problem when the person only has a runner license). Is there an easy way to share a chained script?

    ------------------------------
    Michael Codreanu | Specialist, Supply Chain Master Data
    Apotex Inc | 4166240306
    ------------------------------


  • 2.  RE: How to send chained query scrips through email (or how to save in folder)?

    Posted 05-11-2022 02:21
    Hi Michael,

    I guess the chained scripts all use the same Excelfile. 
    I would suggest to publish all the scripts to the Excelfile and then just share the Excelfile.

    ------------------------------
    Jan van Asseldonk | Consultant
    CTAC | +31629078169
    ------------------------------

    Original Message


  • 3.  RE: How to send chained query scrips through email (or how to save in folder)?

    Posted 05-11-2022 13:47
    I agree with Jan. Scripts are all individual. Chaining Scripts is a Run function. Publishing the Chained Scripts to Excel and then sharing with the Runners would be the most viable option.

    ------------------------------
    Bill Wiseman | Senior Solutions Engineer
    Winshuttle North America | 4255276642
    ------------------------------

    Original Message