Automate Daily SQL Queries in 4 minutes

By Team WayScript

In this tutorial, we schedule a SQL query to run on a daily basis.

Building your Flow

Step One

Drag the SQL Module into your program.

Connect to your SQL Database.

Write your SQL Command.

Optional: Label Your columns to make them accessible variables in WayScript.

Step Two - Set the query to run daily

We are going to user the Time Trigger to run the program daily. Select the 'Time Trigger' under triggers in your flow.

Select the time of day you want your query to run, and then activate the trigger.

All done!

You can use your imported columns to interact with other WayScript modules such as writing to CSVs, sending emails , text messaging and much more!