When the ExpireExecutionLogEntries stored proc is running on my SSRS 2012 server it is causing deadlocks in the reportserver database. It appears that at 2:00AM both SSRS application servers are running the same stored proc at the exact same time which is causing a deadlock on the table ReportServer.dbo.ExecutionLogStorage.

Where do I change the schedule so that server_ssrs01ha runs the proc a different time then server_ssrs01hb ?

Hi Chris, 

According to your description, two stored produce will be run at the exact time and it causes deadlock in the report server database, so you want to change the executing time of schedule, right? 

In SQL Server, we can set the schedules to determine when to execute. In your scenario, you can change the schedule executing time to avoid the deadlock. Please refer to the following steps to achieve your requirement: 

1. Open SQL Server Management Studio and connect to Database Engine. 
2. Expand SQL Server Agent and Jobs, then right-click the required job to select Properties. 
3. Go to Schedules tab and edit the required schedule.

If you have any question, please feel free to ask.

Regards,
Shrek Li