Filter Time Format
Posted: Mon Jun 13, 2016 3:38 pm
I am trying to get a filter to fire at a specific time on a specific day. I current am setting the filter as so:
Weekday -> equal to -> Monday
and Time -> equal to -> 08:00:00
Basically I am wanting the filter to fire on Monday at 8 am. I currently am getting it to execute a SQL query that will make a change to the database upon firing. I gave it the user and password for the MySQL db with the correct privileges. I have manually tested the query and confirmed it works. This is the command I am getting it to execute BTW:
MySQL -u user -ppassword -e "USE zm; UPDATE Monitors SET Function = 'Modect' WHERE Id = 3;"
Any suggestions?
Weekday -> equal to -> Monday
and Time -> equal to -> 08:00:00
Basically I am wanting the filter to fire on Monday at 8 am. I currently am getting it to execute a SQL query that will make a change to the database upon firing. I gave it the user and password for the MySQL db with the correct privileges. I have manually tested the query and confirmed it works. This is the command I am getting it to execute BTW:
MySQL -u user -ppassword -e "USE zm; UPDATE Monitors SET Function = 'Modect' WHERE Id = 3;"
Any suggestions?