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.
- Within the Configurator navigate to: Event Agents >Microsoft SQL Server Trigger Agent > Prerequisites
- For the SQL Server OLE Automation prerequisite click the Modify button and tick Enable Ole Automation.