Example - Simulate the Passage of Time and the Resolution of Some Events

Run part of the Event_Studio_ELM_Agent_Modify_GOSALES.sql script to simulate data changes.

First, change it so that two days elapsed since the ELM Returns Agent sample was last run. Second, for three of the four event instances found the last time that the ELM Returns Agent sample ran, change the follow-up code from -1 to +1. This indicates that only one of the these event instances still requires follow-up and the other instances are resolved.

Procedure

  1. In SQL Query Analyzer, from the File menu, click Open.
  2. Go to c10_location/webcontent/samples/datasources/sqlserver and double-click the Event_Studio_ELM_Agent_Modify_GOSALES.sql file.
  3. On the toolbar, click GOSALES from the list of databases.
  4. In the Query window, under Part 2, select all lines of code that appear after the comments.
  5. From the Query menu, click Execute.

Results

The database is updated with the changes.
Parent topic: Example - Running the Sample ELM Returns Agent Against Changed Data