SQL Server Agent is not expanding and Jobs are not visible

• pols

  SSC Eights!

  Points: 935

  More actions

  March 27, 2023 at 2:50 pm

  #4165556

  Hi,

  We are not able to expand the SQL SERVER Agent. It is taking very long time. It is throwing below 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:

  Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)

  For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-1222-database-engine-error

  --

  If the Agent opens No jobs are visible. Kindly help me to fix the issue.

  Thanks,

  Jo

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  March 28, 2023 at 8:40 am

  #4165868

  Something is blocking/holding a lock on the query the GUI is trying to run.

  Use things like sp_who2 / sp_whoisactive (http://whoisactive.com/) / sp_blitzlock (https://downloads.brentozar.com/FirstResponderKit.zip), to see what is holding a lock and go and fix that process or terminate it.