We will show you How To Automate Your SQL Queries for FREE!

So that you can focus on the things that drive value for your business.

SQL queries are very powerful by themselves, but by automating queries as part of your data flow, you will unlock tons of potential in your data. In this use case, we will explore using the SQL Runner App to automate, insert and update queries. Continue reading to learn how.

If you’re a business owner or executive who is not interested in the technicalities – Schedule a call.

 

Prerequisites:

Before using the SQL Runner to Automate SQL Queries you should:
Have a registered Nom Nom Data account, and your Nominode installed & configured. Here’s how:

 


1.
First, register for a Nom Nom Data account – Click Here To Register
(Using the Nominode is free and no credit card is required)

2. Then follow these steps to install a Nominode – here’s our step by step guide.

Once you have set up a Nominode, you’re ready to get started.

 

Automate Your SQL Queries in Three Easy Steps

 

STEP #1 – Connect Your Database

Create a Generic Database Connection with the details about your database. This connection will be used as the target of your SQL query.

 

STEP #2 – Create A New Task

Create a new Task and select the SQL Runner from the Appl list:

  • Use the Alias field to name your Task
  • Select Run SQL Script With Date Parameters in the Action Type field
  • Use the Target Database Connection field to select the Database Connection that you created
  • Add the SQL query that you want to automate to the SQL Script field
    (Usually, this will be an Insert or Update statement to maintain a dataset that is built from data collected over time)
  • Provide User Defined Parameters, if you are using templates in your query
  • Use the Next Run Start Point field to specify the date in your data, to begin with
  • Set amount of data that you want to process in the Process Increment field
  • Click the Create button

You have successfully completed the creation of your Task.

 

STEP #3 – Create A New Sequence

Create a new Sequence to run your Task automatically:

  • Name your Sequence
  • Enable your Sequence
  • Select Task schedule:
    • Fixed schedule: defined with a CRON expression
    • Trigger Schedule: Set your task to run at the completion of another Task
  • Select the Task that you created
  • Click the Save button
  • Test your Task:
    • You can test your Task before it runs on the schedule by running the Sequence manually.

And that’s it, you have successfully automated your SQL query for free.

For more details, use the ? icons next to the fields in the Task or visit our SQL Runner support page.

 

Learn How Business Owners Save Thousands By Automating Data Entry

Other Articles
pdf to json text converter using nom nom data
How To Convert a PDF to JSON Text!
automation makes happy thanksgiving from nom nom data
How Automation Saved Thanksgiving
How To Automate Your Data Entry