Export (0) Print
Expand All

EventChronicleRule Class

SQL Server 2005

Represents a event chronicle maintenance query to run for each generator quantum in which an event batch arrives into the parent event class.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

public sealed class EventChronicleRule : NamedSmoObject
public final class EventChronicleRule extends NamedSmoObject
public final class EventChronicleRule extends NamedSmoObject

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;

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

ADD
Show:
© 2015 Microsoft