SQL Server Agent fails after installing SQL Server 2019 CU2

Thank you for reporting this. There is a feedback item in https://feedback.azure.com/forums/908035-sql-server/suggestions/39754837-ssms-18-4-sqlserver-2019-cu2-object-explorer-fails. All updates will be provided there as we investigate.

FYI, the bug introduced in CU2 with xp_sqlagent_enum_jobs is now understood and a fix will ship in CU3. Meanwhile, if you're hitting this issue, revert back to CU1. We apologize for any inconvenience we may have caused.

The Cumulative Update 2 for SQL Server 2019 article now has the following warning:

Known issue

There is a known issue with SQL Server Agent in SQL Server 2019 CU2. This will be fixed in the next CU release (SQL Server 2019 CU3).

If you are using SQL Server 2019 SQL Server Agent, it is advised to skip this CU upgrade, and wait for SQL Server 2019 CU3. If you have already applied SQL Server 2019 CU2 and are experiencing issues with SQL Server Agent, please revert to SQL Server 2019 CU1.

Fixed in CU3

FIX: Error occurs when you interact with SQL Server Agent in SQL Server 2019

Tags:

Sql Server

Sql Server Agent

Sql Server 2019

Related

sp_Blitz fails with collation error Execution Plan Warnings cardinality xml data type Creating an Index that is not used by a (SELECT) query reduces performance of that query Is it possible for master, tempdb, model and msdb to have a database_id other than 1,2,3,4 respectively? Increased memory to server, but do I need to change page-file size? SQL Server - Select most recent record from each group when performance is critical SSRS error "something went wrong please try again later" in web portal Shall I use enum when are too many "categories" with PostgreSQL? What is the `TABLE example` syntax called? Is it generally faster to select into a temp table than selecting into an actual table? SQL Query returning same value while using where 1 condition Finding Missing Inverse Relationships

Recent Posts