how to trigger an automation right at the same time when a record is added in a data extension?

Right now i have data extract and file transfer setup with automation but the problem is, automation for data extra itself can only be configured minimum of 1 hour based on automation.

But I would like to trigger the automation as soon as a record is added in a data extension. How to do that?

1 Answer 1


If the record is added to the data extension through another API-based process (such as a landing page, or a client you created), you can try adding an additional call to execute your automation.

Interaction with Automation Studio via the Web Service SOAP API

You can make the same request in AMPscript using InvokePerform(). Here's an example:

Manage Automation via AMPScript API

  • 1
    You might want to handle errors with this call as if the automation is already running when it is called, it will fail
    – 0xsegfault
    Sep 18, 2017 at 19:08
  • 1
    I do not have an option to trigger anything by API as i am not working with API.
    – kuml
    Sep 19, 2017 at 12:09
  • Is there any other way to do this? Can I trigger a query when new record is added and that query can trigger the automation?
    – kuml
    Sep 19, 2017 at 12:11
  • Can I use activities to trigger my automation?
    – kuml
    Sep 19, 2017 at 15:07
  • @kuml The script (aka SSJS) activity in Automation Studio can be used to execute another automation, by API.
    – Chris
    Sep 19, 2017 at 19:35

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .