spMFUpdateContextMenuQueue

Returns

• 1 = Success

• -1 = Error

Parameters

@ID int

• ID of the row in dbo.MFContextMenuQueue to reprocess

Purpose

Reprocess queued “context menu” actions (action type 5) that did not complete on the first attempt.

Additional Info

• Intended for a SQL Agent job to trigger on an interval and process stale queue items.

• Each attempt increments the update cycle. The default retry limit is 5.

• When @ID is provided, that specific row is targeted; otherwise the oldest unprocessed row is selected.

Examples

EXEC dbo.spMFUpdateContextMenuQueue @ID = 1;

Changelog

Date	Author	Description
2020-01-07	LC	Add routine to clean up the queue
2019-12-06	LC	Create procedure