Automate

 View Only

  • 1.  Trigger Query from Power Automate

    Posted 4 hours ago

    I have Query that updates a SQL table that I would like to trigger using Power Automate. 

    is this possible?



    ------------------------------
    Jane Dobbs
    Canadian Pacific Railway
    ------------------------------


  • 2.  RE: Trigger Query from Power Automate

    Employee
    Posted an hour ago

    Hi Jane

    Yes it's possible. 

    One way is via the command line interface:

    However, if you have an RPA tool/"bot" run scripts, it requires a different type of license - please see "Bot license" on this page: https://help.precisely.com/r/t/AEV-0001/2025-10-09/Automate/pub/Latest/en-US/Automate-Product-Support-and-Licensing/Automate-license-definitions

    Prior you had asked about scheduling the Query runs, which is possible in Studio Manager and Evolve, without using an RPA tool/"bot". The best choice would be dependent on your use case(s).

    Best Regards,

    Sigrid



    ------------------------------
    Sigrid Kok
    *Precisely Software Inc.
    ------------------------------

    Original Message