Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Event chronicle rules maintain the data in event chronicle tables. Each event chronicle has a name, an action, and an action time-out, and a parent event class.
For more information about event chronicle rules, see Defining Event Chronicle Rules.
For information about controlling the strict accuracy of event batch processing, see Specifying the Event Processing Order.
The following example shows how to create an event chronicle rule that simply copies all events to a chronicle:
// Define the event chronicle rule EventChronicleRule ec1Rule = new EventChronicleRule(flightEvents, "FlightEventChronicleRule"); ec1Rule.Action = "INSERT MyAppSchema.FlightEventChronicle " + " (LeavingFrom, GoingTo, Price) " + " SELECT LeavingFrom, GoingTo, Price " + " FROM MyAppSchema.FlightEvents;"; ec1Rule.ActionTimeout = new TimeSpan(0, 1, 20); flightEvents.EventChronicleRule = ec1Rule;