Learn how to trigger an Automate task when a specific operation is performed on a SQL or Oracle database. This guided tutorial shows how to use the database trigger in Automate. In this video you’ll learn how to:
- Configure the database trigger settings and enable notifications
- Test the database trigger connection
- Fill out prerequisites for what to track
- Apply the database trigger to your task
Watch this chapter now to learn more about the database trigger.
[Voiceover:] Today we are going to take a look at the Automate database trigger. You'll see a variety of options that need to be configured so that Automate can communicate with a desired database. Let's go through and select our database type. You can choose between sequel and oracle. [00:00:30] And we'll also need to fill out all of the required fields. One thing to keep in mind is query notifications must be granted to the user. Simply running the highlighted query will enable notifications. [00:01:00] Here we can input the database we want to monitor. With everything filled out, let's test our connection to make sure we've done everything correctly. If everything was inputted correctly, a successful prompt will appear.
Next we'll fill out all of the prerequisites. We'll need to type in the specific table name we want to keep an eye on. And decide what changes will trigger my task. There is a good variety to choose from. We can track our record being inserted, [00:01:30] deleted or updated. Or even changes like a table being dropped or altered. Once all of our selections are made, we can click okay and this trigger will be applied to our task.