Sending Tag Data to SQL Database at specific Times

Ignition
1

Hello,
I'm brand new to Ignition and our company is in the process of implementing the system for all of our printing presses. We are a small company and I'll share that I am not a programmer but am trying to learn.

We have encoders set up on each of our printing presses captures footage totals. Our shifts are from 3 AM- 3 PM each day. We currently have the encoders set to record footage and are stored on a historian tag in Ignition. We have 16 printing presses currently logging footage and each press has it's own historian tag and perspective session.

What we want to be able to do is to have Ignition take the data from the historian tag at 3 AM and 3 PM and send the total footage recorded to a SQL database that has 3 columns. WorkCenter, Date and Total Footage.

I have created the named query to insert the data into the database. What I am struggling to do is have the query run at 3 AM and 3 PM each day. Is there a way to have a query executed at specific times?

2

Use a gateway scheduled event. That script would collect the history and run the named query. You'll have to learn some jython. (Come on in! The water is fine!)

1 Like
3

Thank you! That worked perfectly