Changing Event File Paths in the Servicing Director Event Manager Database

Changing Event File Paths in the Servicing Director Event Manager Database

Some Event Manager events have file paths as part of their criteria that are mostly user defined file paths. For example, a report event can be user defined to export the report to a user chosen file location on your server or network. If your Servicing Director server or network should change in a way which makes the user defined locations invalid, then it will be necessary to change some or all of these event file paths.

Note: The procedure below is for your local IT or system administrator familiar with Windows and Microsoft SQL server.

The following procedure describes searching the Event Manager database for values which are likely file path values, providing a quick means to find the events to check and possibly change using the Event Manager application.


  1. Open SQL Server Management Studio.
  2. Click New Query.
  3. Select the SvcEventMgr database on the New Query toolbar.

  4. Enter the following command:

USE SvcEventMgr
SET TEXTSIZE 320
SELECT Eventtable.cEventName AS RecurringEventName, CalendarTable.cCriteria AS CriteriaWithFileReference
FROM CalendarTable INNER JOIN EventTable ON CalendarTable.cEventCode = EventTable.cEventCode
WHERE (CalendarTable.cCriteria LIKE '%:%')
OR (CalendarTable.cCriteria LIKE '%\\%')

  1. Click the Execute button on the toolbar to run the command. The results should be a list in the lower pane, which is a list of recurring, scheduled events that have saved criteria likely containing a file path combined with other values. The Recurring Event Name on the list is the name of the event.
  2. Check the list displayed to verify the file paths are still valid.
  3. If a file path is not valid, note the Recurring Event Name on the list, and update the event with that name in the Event Manager application as follows:
    1. Open the System Administration application.
    2. Click Event Manager.
    3. Select the View menu > Recurring Instances.
    4. Locate any event you want to change on the Scheduled Instances list.
    5. Click on the event you want to change one at a time.
    6. Click Criteria.
    7. Edit the file paths displayed on the event Criteria screen or for some events, click OK on the Criteria screen, and you will be prompted from the file path.
    8. Click OK to save the changes.
    9. Repeat these Criteria screen steps on any other events on the Instances list you want to change.
    10. Repeat the above using the Event Manager View Menu>One Time Instances list.
  4. When all the event file paths are updated, close the Event Manager and close the SQL Server Management Studio.

ArticleNumber:

000049094