I have the following trigger that uses a table name SOT (sales oreder table). Every time the table updated the trigger fires.
Thers is another table name DLT (delivery table) and I need to copy sales order to delivery table. Coping procees is fine but when I try to updated table DLT takes longer than normal time (30 seconds) because of TR_SOT trigger. I was wondering if I can add a trigger to DLT table so suppress/ignore (not disabling) the TR_SOT triger from being executed . Something like this.
Thank you for your help.