exec sp_executesql N'begin try
begin transaction
declare @scheduleId int 
select @scheduleId = ScheduleId from dbo.Job where JobId = @jobId
IF @scheduleId = 0 or @scheduleId = -1
	begin
        INSERT INTO dbo.scheduledata 
                        (timezone,NAME,freqtype,freqinterval,freqrelativeinterval, 
                         freqrecurrencefactor, 
                         startdate,starttime,enddate,endtime) 
        VALUES     (@timeZone,@scheduleName,@freqType,@freqInterval,@freqRelativeInterval, 
                        @freqRecurrenceFactor,@startDate,@startTime,@endDate,@endTime);
        Update dbo.Job 
        set JobName = @jobName, Steps = @steps, WarehouseId=@warehouseId, NotificationOptions=@notificationOptions, ScheduleId=Scope_identity(), LastRun=@lastRun, NextRun=@nextRun, ModifiedBy=@modifiedBy, LastModified=GetUTCDate()
        where JobId = @jobId
	end
ELSE
	BEGIN
		 update dbo.ScheduleData set TimeZone=@timeZone, Name= @scheduleName, FreqType=@freqType,
		 FreqInterval=@freqInterval, FreqRelativeInterval=@freqRelativeInterval, FreqRecurrenceFactor=@freqRecurrenceFactor, StartDate=@startDate,
		 StartTime=@startTime, EndDate=@endDate, EndTime=@endTime where Id=@scheduleId

		 Update dbo.Job 
		 set JobName = @jobName, Steps = @steps, WarehouseId=@warehouseId, NotificationOptions=@notificationOptions, ScheduleId=@scheduleId, LastRun=@lastRun, NextRun=@nextRun, ModifiedBy=@modifiedBy, LastModified=GetUTCDate() 
		 where JobId = @jobId
	END
 commit
 end try
 begin catch
 rollback
 end catch',N'@timeZone nvarchar(4000),@scheduleName nvarchar(4000),@freqType int,@freqInterval int,@freqRelativeInterval int,@freqRecurrenceFactor int,@startDate int,@startTime int,@endDate int,@endTime int,@jobId int,@jobName 
nvarchar(4000),@steps nvarchar(4000),@warehouseId uniqueidentifier,@notificationOptions nvarchar(4000),@modifiedBy nvarchar(4000),@lastRun datetime,@nextRun datetimeoffset(7)',@timeZone=N'New Zealand Standard 
Time',@scheduleName=N'temporaryName',@freqType=8,@freqInterval=127,@freqRelativeInterval=0,@freqRecurrenceFactor=0,@startDate=20210402,@startTime=101900,@endDate=0,@endTime=0,@jobId=1598,@jobName=N'ArbIT_Refresh',@steps=N'[{"Sequence":0,"JobId":0,"Name":"Delete_All_Transactions","Type":"Rule","Parameters":[{"ParameterLabel":"Module Name","ParameterShortLabel":null,"Value":["ArbIT_VisitData"],"ValuePair":null,"LookupType":"Singular","DisplayedValue":"ArbIT_VisitData"}],"AdditionalArguments":{"warehouseId":"7837214c-ac59-4290-89e3-19cb327cdf32","ruleId":5},"NextRunTime":null,"WarehouseId":"7837214c-ac59-4290-89e3-19cb327cdf32"},{"Sequence":1,"JobId":0,"Name":"Delete_All_Transactions","Type":"Rule","Parameters":[{"ParameterLabel":"Module Name","ParameterShortLabel":null,"Value":["ArbIT_JobData"],"ValuePair":null,"LookupType":"Singular","DisplayedValue":"ArbIT_JobData"}],"AdditionalArguments":{"warehouseId":"7837214c-ac59-4290-89e3-19cb327cdf32","ruleId":5},"NextRunTime":null,"WarehouseId":"7837214c-ac59-4290-89e3-19cb327cdf32"},{"Sequence":2,"JobId":0,"Name":"ArbIT_Dim_Load","Type":"Integration","Parameters":[],"AdditionalArguments":{"warehouseId":"7837214c-ac59-4290-89e3-19cb327cdf32","integrationId":1050},"NextRunTime":null,"WarehouseId":"7837214c-ac59-4290-89e3-19cb327cdf32"},{"Sequence":3,"JobId":0,"Name":"ArbIT_Fact_Load","Type":"Integration","Parameters":[{"ParameterLabel":"Period","ParameterShortLabel":null,"Value":[],"ValuePair":null,"LookupType":"Multiple","DisplayedValue":""}],"AdditionalArguments":{"warehouseId":"7837214c-ac59-4290-89e3-19cb327cdf32","integrationId":1051},"NextRunTime":null,"WarehouseId":"7837214c-ac59-4290-89e3-19cb327cdf32"}]',@warehouseId='7837214C-AC59-4290-89E3-19CB327CDF32',@notificationOptions=N'{"Type":"email","SuccessReceipients":"martin.andrew@treescape.co.nz","FailureReceipients":"martin.andrew@treescape.co.nz"}',@modifiedBy=N'587775f6-0c12-49d5-97b1-57e54a1f9ea2',@lastRun=NULL,@nextRun=NULL