Copy Code Trigger Definition

                 
                    CREATE trigger [dbo].[TR_TERM_DELETE] ON [dbo].[TERM] AFTER DELETE
                    AS 

                    set nocount on
                    
                    declare @ChangeAgentID uniqueidentifier
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENTFROMCONTEXT @ChangeAgentID output
                    
                    exec dbo.USP_SCHEDULEDATE_CLEANUP @CHANGEAGENTID