Creating a Timer Event Trigger
This section describes how to create a timer event trigger.
To create a timer event trigger
1. Right-click in the location where you want to add a new trigger resource in the resource tree, and select New Trigger.
Only valid trigger locations, like within My Home or Shared, offer the option to create a new trigger.
2. In the New Trigger window, supply a name for the trigger and click OK.
The trigger editor opens on the right.
3. Enable the trigger by selecting the Enable Trigger check box.
The Enable Trigger check box can be set to enable or disable the trigger at any time. Just save the trigger to set a changed value.
4. For Condition Type, select Timer Event.
5. In the Condition section, specify the schedule for the trigger. You set a timer event trigger to execute one time or repeat it at intervals based on minutes, hours, days, weeks, months, or years and specify the recurrence as follows:
a. To schedule the event to be executed one time, select Exactly Once and skip directly to the Start on section to schedule when the trigger is to be fired.
b. To schedule a periodic event, select Periodic, specify the refresh frequency (Refresh every), and select the time unit from the drop-down list.
c. To schedule a periodic event, also specify the date and time for the first execution using the Start on (date) and at (time) fields.
The date and time entered specify the moment of the first triggering event. For example, if a daily event is set for 11:55 AM three days in the future, it runs at 11:55 AM in three days and then every day at the same time thereafter.
The date and time also mark the beginning of the Refresh every period. For example, if you specify Refresh every 1 hour, and you specify 9:35 AM in the Starting at section, a firing condition occurs at thirty-five minutes past the hour every hour from 9:35 AM onward.
If any recurrence restriction is in effect), the trigger can only fire and initiate an action within the time range and on the selected day(s). The actual firing of an action is independent of the period you specify; that is, queuing a firing does not change when the next firing condition will be met.
d. Optionally, check Enable for the Recurrence Restriction (Optional) and check days of the week and a time range to restrict trigger operation to a time window on specified days of the week.
By default, no recurrence restriction is in effect, and so a scheduled trigger fires whenever the specified period has elapsed. No recurrence restriction is in effect if every day of the week is selected and the start and end time are the same.
The recurrence restriction window begins a period during which a trigger fires and initiates the specified action. If the trigger conditions are met outside of the restricted window, then the trigger queues a firing event for the next recurrence restriction start time. The actual number of firing events allowed in the queue is configurable. See
Getting Information about a Resource.
If the trigger should be restricted to firing within a specific window of operation:
— Specify the days on which the trigger can fire.
— Specify the Start and End time when the trigger can fire.
With Enable checked, the trigger fires only on the selected days of the week and during the time window specified by the Start and End times, subject to the following rules:
— If Start and End time are identical, no time restriction is applied.
— If End time is greater than Start time, the trigger is restricted to fire only within the time window starting at Start time (inclusive) and ending at End time (inclusive).
— If End time is less than Start time, the trigger is restricted to fire only within the time window starting at End time (inclusive) and ending at Start time of the next day (inclusive).
More complex scheduling can be created by combining the effects of multiple triggers that can call the same actions with different scheduling parameters.
Note: If you check Enable in the Recurrence Restriction (Optional) section but you do not check any day of the week, the trigger does not have any valid firing period and is effectively disabled regardless of other settings.
e. If the TDV Server is to be a member of a clustered group of servers, then check. Only once per cluster to avoid multiple actions being triggered simultaneously from every TDV Server instance.
6. For Action Type, select the type of action to be triggered from the drop-down list.
7. In the Action section, enter the options for the action type. The options are described in the section
Action Pane.
Select Exhaust output cursors, if the procedure is a SQL script that contains a PIPE cursor.
For example, if you want email notifications sent, type and confirm the email addresses of the recipients to receive notification, as needed. You can specify a list of email addresses in the address fields by separating each one with a comma (,) or semicolon (;).
8. Click the Info tab. In the Maximum Number In Queue field in the Queue Properties section, specify the maximum number of trigger firings to queue if multiple periods have elapsed while a recurrence restriction prevents the trigger from firing.
Most triggers should fire only once within the next available active operation window, but there might be cases when more than one trigger action should be initiated at the next opening of the recurrence restriction. This number should not be negative.
9. Save the trigger.
If the Save option is not enabled, select File > Refresh All to refresh the resources and enable the Save option.