How do you use cloud databases? Take the survey.

Performance tip rg_job_history prevents updates with CU 22 for SQl Server 2017

Hi all
at is a performace tip of creating an filtered index on table msdb.dbo.sysjobhistory.
This tipp works fine, unless you want to update your servers :-(
This index prevents updating with error 1934 at msdb110_upgrade.sql. 
So If anybody has problems here, just dop the index. and recreate it. 

Searching for this failure took me some time ...

Could anybody of the red-gate team add some information to the tip please? Thanks. 

Sign In or Register to comment.