How can we insert data in custom table when Error message comes up in JobQueue table. I am trying to add trigger on JobQueue table and tried Insert, Update and Delete events but its not working on any of these events. Please help in implementing this.
You would need :
1.) a new process on table JobQueue that would trigger on event update
2.) generation condition on this process which would check if ErrorMessages attribute has changed.
gen condition would be :
Value = $ErrorMessages[o]$ <> $ErrorMessages$
after that You can add any desired function to this process