I am currently trying to use a stored procedure to report data at 6:00am every day. Aside from waiting until 6:00am and enabling the stored procedure to execute each day I am wondering if it’s possible to create a tag whose value changes to ‘1’ each time the server clock reads “06:00:00”.
Thank you for your time.
Yes, you can create a DB SQLTag that is an expression. In the SQLTags Browser right click and select New Tag > DB Tag… There give the tag a name and boolean datatype in this case. Select the Expression / SQL tab on the left and choose Expression. Enter the following expression and press OK:dateFormat(now(0), "HH:mm:ss") = "06:00:00"Make sure the Scan Class associated with the new DB tag runs at least every second. If it runs slower than a second you can miss second 0 in your case. You may want to remove the seconds altogether in the expression.
That expression seems to work. Thank you very much for your help.