After installing CU2 our SQL server agent randomly stops working. If you go to check on the status of the agent by opening Job Activity Monitor, it comes up blank for a while then throws an error:
Failed to retrieve data for this request.
(Microsoft.SqlServer.Management.Sdk.Sfc)For help, click:
https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476—————————— ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)
A severe error occurred on the current command. The results, if any,
should be discarded. (Microsoft SQL Server, Error: 0)For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=15.00.4013&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
Any clue what could be causing this?
Best Answer
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:
Fixed in CU3
FIX: Error occurs when you interact with SQL Server Agent in SQL Server 2019