TR_APPEALMAILINGACTIVATEEMAILJOBSCHEDULE_UPDATE_EMAILJOBSTARTWITHOFFSET (Trigger)

                
                    create trigger TR_APPEALMAILINGACTIVATEEMAILJOBSCHEDULE_UPDATE_EMAILJOBSTARTWITHOFFSET on dbo.APPEALMAILINGACTIVATEEMAILJOBSCHEDULE after insert,update not for replication
                    as begin
                        set nocount on;
                        
                        declare @CURRENTDATE datetime = getdate();
                        
                        if not update(EMAILJOBSTARTWITHOFFSET)
                            begin
                                update dbo.APPEALMAILINGACTIVATEEMAILJOBSCHEDULE set 
                                    EMAILJOBSTARTWITHOFFSET = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEWITHTIMEOFFSET(inserted.EMAILJOBSTART, 0),
                                    CHANGEDBYID = inserted.CHANGEDBYID,
                                    DATECHANGED = @CURRENTDATE
                                from dbo.APPEALMAILINGACTIVATEEMAILJOBSCHEDULE
                                inner join inserted 
                                    on APPEALMAILINGACTIVATEEMAILJOBSCHEDULE.ID = inserted.ID
                            end
                        
                    end