I have couple of simple triggers on a particular field on the database but when testing them they don't fire.
I double checked everything and it all seems fine. One of them used to be working even few weeks ago and now it wouldn't fire.
I checked the database and triggers are there. Event Log shows creation of triggers. It's just that when the value is changed in the DB they don't fire.
I checked thy all the services are up and running including SQL trigger in the database server.
When I tried to Queue (by right clicking the task and selecting queue up) task, Event Log did report that my license key for SQL store has expired (error msg: "Queued Task 'ACAT 1: Email trigger' failed to run because SQL Server Store license expired")
How do I troubleshoot when things don't work to figure out where is the hold up?
Are there additional logs/methods?
By chance are you on SQL Express?
I ran into this same issue. Everything looked good in the task, on the triggers, just nothing would happen. It turned out in my case to be this:
Task Centre triggers won't fire
Environment: SQL_EXPRESS:
Version: 15.0.3.2332
Module: UNKNOWN
Description:
SQL Express installs to login its Server Service as the Network Service account (whereas full SQL Server uses Local System. Don't know why, ask MicroSquish!). This causes a DCOM permission conflict with the TaskCentre SQL Agent Service that installs as Local System.
The solution is to mess with the DCOM Permission using DCONCNFG or you can simply change the login account the SQL Express uses.
Jennifer Strawn
Accounting & Association Software Group