A trigger is an event that causes a row of data to be written to your database table. A trigger event can be either a point value change, a timer event, or a calendar event. You can assign a different trigger for each row, or an identical trigger to any number of rows. An action can be configured to execute on every trigger event, or you can assign trigger conditions that are avaluated whenever a trigger occurs, to determine if the action should be executed.
The three kinds of triggers are:
Point Change fires whenever a specified trigger point changes.
Repeat Timer fires cyclically, each time the number of seconds elapses.
Time of Day fires at the time you specify. You can enter:
A number, indicating a specific value. For example, a 0 in the seconds field would cause the event only on the 0th second of the minute. A 30 would indicate only on the 30th second of the minute.
A list of numbers, separated by commas. For example, entering 0,15,30,45 in the minutes field would indicate that the event should fire on the hour and at 15, 30 and 45 minutes past the hour.
A range of numbers, separated by a dash. For example, entering 8-18 in the hours field would indicate that the event should fire every hour from 8 a.m. to 6 p.m.. Ranges can be mingled with lists, as in 0,4,8-16,20.
An asterisk (*) indicates that the event should fire for every possible value of the field. For example, a * in the seconds field would cause the event to fire every second. A * in the hours field would cause the event to fire every hour.
To regularly log a record on specific days of the week, please refer to Section 6.7, “Setting Trigger Conditions”.
The ranges of the fields are:
The year and month are entered differently here than for the Gamma localtime function, as explained in Time Conditions.
would cause a row to be logged at 8:45 every day, every month, and every year.
would cause a row to be logged every hour on the 15th day of each month, every year.
would cause the event to fire every second for 5 minutes, every two hours between 8 a.m. and 6 p.m.
Copyright © 1995-2010 by Cogent Real-Time Systems, Inc. All rights reserved.