Follow-On Topics

Related Topics

# About the Microsoft SQL Server Trigger Agent

The Microsoft SQL Server Trigger Agent is a service that sits between King Task Centre and SQL Server, installed onto any SQL Server instance. It is responsible for both maintaining the triggers in SQL Server and for handling the running of a task once a trigger has been fired.

When a SQL Server trigger is fired, a connection is made to the Agent service which then launches the relevant task.

King Task Centre also supports the use of triggers on a SQL Server failover cluster, enabling the firing of triggered tasks from whichever server in the cluster is active at the time. An Agent must be installed on each node, starting with the active node. However, because all are monitoring the same SQL Server instance, the King Task Centre client sees only a single Agent registration.

Copyright © 2018 Quadrant Software B.V. All rights reserved.