Jan 01/2019 Use triggers in MS SQL to determine your clients’ transaction interval Use triggers in MS SQL to determine your clients’ transaction interval for any Delete, Update or Insert. We needed to create SQL Jobs to insert data from multiple tables into a single table from 2 different databases from 2 different locations.