Event Tools - MS SQL Server Trigger

The MS SQL Server Trigger Tool is used to create a Task Step that utilises the Microsoft SQL Server trigger functionality to create a trigger on a table of a specified SQL data source. When a specified data modification is attempted, such as an attempt to add or delete a table row, the trigger then causes a Task to run.

The trigger creates virtual tables for inserted/updated and deleted rows which may be mapped to Task variables so that the data may be used in other Steps within the Task.

If a Database Query (ODBC) Step is used within the Task to retrieve a recordset from the SQL data source, then the memory feature may be used in a subsequent Step to memorise all of the data into a Repository.

» Third party product and technology license disclaimer

Business Benefits

If you manually hand code and maintain MS SQL Triggers you will probably be a technical person who works within the IT department of a company or an IT consultancy. Either way, the TaskCentre MS SQL Server Tool will not only save you a great deal of time by producing the trigger for you, but it will maintain it for you also.

Its as simple as setting the conditions of the Trigger. All the script is automatically generated and because TaskCentre internally manages these MS SQL Sever Triggers you will not lose them when you come upgrade your database.

By using the MS SQL Trigger Tool in conjunction with TaskCentre’s other Tools you are able to effortlessly build and maintain powerful automated business processes that address the needs of your business.

Want to learn more about what TaskCentre can provide you and your company?

If you work within the IT department of an organisation, please visit our home page and discover the benefits TaskCentre can provide you and your company. Alternatively, if you work for an Independent Software Vendor (ISV) or IT consultancy, please visit our Partner Focus page and discover the benefits our existing partners are already enjoying or download the documents below: