dbo.QBM_TIDialogSchedule

1  create   trigger QBM_TIDialogSchedule on DialogSchedule  for insert not for Replication as begin declare @jetzt datetime = getutcdate() declare
2 @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate() BEGIN TRY if exists (select top 1 1 from inserted) goto start return
3 start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') if exists (select top 1 1 from inserted i where dbo.QBM_FGITimeIsValid
4(i.starttime) < 0 ) begin  raiserror( '#LDS#The time entered is not valid, must be between 00:00 and 23:59 or empty.|', 18, 3) with nowait end  update 
5DialogSchedule set EndDate = '2200-01-01' , XDateUpdated = @Xdate , XUserUpdated = @XUser from DialogSchedule s join inserted i on s.UID_DialogSchedule
6 = i.UID_DialogSchedule where s.EndDate is null update DialogSchedule set NextRun = dbo.QBM_FGIScheduleNextRun ('1899-12-31'  , '1899-12-31'  , case  when
7 isnull(s.StartDate, '1900-01-01') > @jetzt and s.FrequencyType not in ('Week', 'Month', 'Year', 'Day') then s.StartDate when isnull(s.StartDate, '1900-01-01'
8) > @jetzt and s.FrequencyType in ('Week', 'Month', 'Year') then dateadd (dd, -1, s.StartDate) when isnull(s.StartDate, '1900-01-01') > @jetzt and s.FrequencyType
9 in ('Day') then dateadd (hh, -1, s.StartDate) else @jetzt end , s.StartTime  , s.FrequencyType  ,  case when isnull(s.StartDate, '1900-01-01') > @jetzt
10  and s.FrequencyType not in ('Week', 'Month', 'Year', 'Day') and s.FrequencyType not like 'WD[_]%' then 0 when s.FrequencyType like 'WD[_]%' then s.Frequency
11 else 1 end , s.FrequencySubType  , isnull(tz.CurrentUTCOffset, 0)  ) , XDateUpdated = @Xdate , XUserUpdated = @XUser from DialogSchedule s join inserted
12 i on s.UID_DialogSchedule = i.UID_DialogSchedule left outer join DialogTimeZone tz on s.UID_DialogTimeZone = tz.UID_DialogTimeZone where isnull(s.EndDate
13, '2200-01-01') > @jetzt  and s.Enabled = 1 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 
14