Condition

Specify the condition that causes the event to fire.

This condition typically involves either a time operation or a database calculation, or both.

Each condition consists of one of these values:

  • A Boolean keyword
  • Two non-Boolean expressions separated by a comparison operator

Consider these examples:

  • This example causes the event to fire when seven days have elapsed since the current result of the database function dbo.LastEntryDate():

    DATEDIFF(day, DBFUNCTION(LastEntryDate), CURDATETIME()) > 7

  • This example causes the event to fire when the balance on a certain customer's order is greater than $10,000:

    DBFUNCTION(OrderBalance, GC(BigCustNum)) > 10000

  • This example causes the event to fire on the first day of each month:

    DATEPART(day, CURDATETIME()) = 1

For information on conditions and triggers, see Event Triggers.