I have different types of reports that sends out to the client. I have created different stored procedure for different types of reports and every procedure runs as SQL Job in every 15 minutes. During that 15 minutes if report has been schedule then I am updating report parameter using below code and sends out to the client.

UPDATE [ReportServer].[dbo].[Subscriptions]

SET [Parameters] = ''

,ExtensionSettings=''

WHERE subscriptionId=@SubscriptionId

UPDATE [ReportServer].[dbo].[Subscriptions]

SET [Parameters] = @ParameterString

,ExtensionSettings=@ExtensionSetting

WHERE subscriptionId=@SubscriptionId

EXEC msdb..sp_start_job @job_name = @ScheduleID

WAITFOR DELAY '00:01:30'

In my case two stored procedures are executing concurrently and try to execute above code for different subscriptionId and ScheduleId.

Randomly reports are not sent out to the client and I have checked ExecutionLog2 it is also missing entry.