You can use this stored procedure [ssb].[Cleanup] to remove processes that have already been executed. The [ssb].[Cleanup] stored procedure scans for rows in [ssb].[DialogsMap] that contain a fldLastActiveDate that already passed keepAliveInterval 5 times, and removes them and their Sql Service Broker queues and services. It also scans and removes queues and services, that are not registered in [ssb].[DialogsMap].
To enable the cleanup procedure, in web.config file, under sequence.engine\services , configure the following parameters for the service PNMsoft.Sequence.Notifications.Sql.SqlServiceBrokerNotificationServiceFactory:
| Parameter | Description | Values |
|---|---|---|
| cleanup | Whether or not to run the clean-up procedure. | true false (default) |
| cleanupInterval | Determines the interval for running the cleanup procedure. Format HH:MM:SS | Values must be positive and greater than zero. Default: "02:00:00" |
| cleanupTimeout | Determines the execution timeout. An attempt to execute a command will wait indefinitely. Format HH:MM:SS | Zero indicates no limit. Example: "00:30:00" |
| keepAliveInterval | Determines the interval for updating the fldLastActiveDate parameter in the [ssb].[DialogsMap] Format HH:MM:SS | Values must be positive and greater than zero. Default: "00:05:00" |
