Skip to content

Knowledge Base

Business Process Automation Platform

SQL triggers not working. Error code 0x80037000


Tasks triggered by the SQL trigger agent do not run and the TaskCentre event log records the following error code:



This error occurs because by default versions of SQL Server starting with SQL Server 2005 provide a restricted set of features.


The resolution is to enable OLE Automation by using the TaskCentre Configurator tool found from the Start menu in the Program group for TaskCentre.

  1. Within the Configurator navigate to: Event Agents >Microsoft SQL Server Trigger Agent > Prerequisites
  2. For the SQL Server OLE Automation prerequisite click the Modify button and tick Enable Ole Automation.