Configure Database Scheduled Tasks

Explanation

Database scheduled tasks remove complete and incomplete log entries from the Communication Log and notify administrators about incomplete and erroneous communications.

For more information about communication types, see Communication Monitoring.

Database Scheduled Tasks

1. Purge Communication Log

The Purge Communication Log scheduled database task removes both complete and incomplete communication log entries. This task can be scheduled using the Database Task Schedules page. When this task runs, it clears all communication log entries that were recorded one week (default value) before task execution.

The following table describes the object property defined in the Object Properties page that handles the database scheduled task Purge Communication Log.

Property Name Description
COMM_LOG_EXPIRY Used by the Purge Communication Log database scheduled task. Property Value is a number that specifies the time in days, after which both complete and incomplete communication activity is deemed expired and will be deleted from the system.

Default Property Value: 7 (1 week)

You can change the default values in the Property Value field from the Object Properties page.

2. Alert Job in Communication Log

The Alert Job database scheduled task triggers an event identifying all communications that are not complete (i.e., they do not have end state log records of communication type Request Completed, Event Completed, or Error). This task can be scheduled using the Database Task Schedules page. When this task executes, it triggers the ADMON_INCOMPLETE_ALERT event for all communication that has not completed 5 minutes (default value) before the execution of the task.

The Event Action page can be used to create an action to respond to the ADMON_INCOMPLETE_ALERT event, for example, send an email to administrators.

The following table describes the object property defined in the Object Properties page that handles database scheduled task Alert Job in Communication Log.

Property Name Description
COMM_INCMPLT_ALERT

Used by the Alert Job in Communication Log database scheduled task. Property Value is a number. This value specifies the time in seconds when communication is considered incomplete and a ADMON_INCOMPLETE_ALERT event should be triggered.

Default Property Value: 300 (i.e., 5 minutes)

You can change the default values in the Property Value field from the Object Properties page.

Prerequisites

Not applicable.

System Effects